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

title	Edit Rows in the Results Pane (Visual Database Tools) | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
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	stevestein
ms.author	sstein
manager	craigg

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