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

title	Edit Rows in the Results Pane
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	ssms
ms.topic	conceptual
f1_keywords	vdt.pane.results
helpviewer_keywords	View Designer, Results pane modifying rows Query Designer [SQL Server], Results pane Results pane
ms.assetid	de36f636-cfe9-4ae6-a474-06e9c51f9f0c
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Edit Rows in the Results Pane (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] 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)