edit-rows-in-the-results-pane-visual-database-tools.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords
Edit Rows in the Results Pane	Edit Rows in the Results Pane (Visual Database Tools)	markingmyname	maghan	01/19/2017	sql	ssms	conceptual	vdt.pane.results	View Designer, Results pane modifying rows Query Designer [SQL Server], Results pane Results pane

Edit Rows in the Results Pane (Visual Database Tools)

[!INCLUDESQL Server]

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 Work 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

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