How to: Edit Rows in the Results Pane (Visual Database Tools)

In many cases, you can edit the data in the Results Pane. For more detailed information about changing data see Rules for Updating Results (Visual Database Tools) and Working with Data in the Results Pane (Visual Database Tools).

To edit data in the Results pane

1. Run the query or view that has the data you want to edit.

2. Navigate to the cells containing the data you want to change.

3. Type in the new data.

   Note

   To enter a null value type NULL in capital letters. The Results pane will format the word with italics to indicate it is a null value and not a string.

4. Save your changes by leaving the row.

See Also

Concepts

Working with Data in the Results Pane (Visual Database Tools)
Rules for Updating Results (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance