Add New Rows in the Results Pane (Visual Database Tools)
Applies to: 
SQL Server
You can add new data either by typing it in or by pasting it from another program such as Notepad or Excel. A row to be pasted must have exactly the same number and types of columns as the table into which you are pasting. You can paste multiple rows into the Results pane at once.
For information about how to enter data see Rules for Updating Results (Visual Database Tools).
To add a new data row
Navigate to the bottom of the Results pane, where a blank row is available for adding a new data row.
The initial values for all columns will be NULL.
Tip
To go directly to the first empty row use the navigation bar at the bottom of the Results pane.
If you are pasting rows from the Clipboard, select the new row by clicking the button to its left.
Note
If one or more of the rows you're pasting can't be committed to the database you will receive a message telling you which row(s) couldn't be committed.
Enter the data for the new row. If you are pasting, choose Paste from the Edit menu.
Leave that row to commit it to the database.
If an error occurs when you save the row the Query and View Designer displays a message and then returns you to the row you were editing. You can then:
Resolve the error by making further edits in the row.
Cancel the edit by pressing ESC. If you press ESC while in a cell that you changed, the changes for that cell are canceled. If you press ESC while in a cell you have not changed, the changes for the entire row are canceled.
See Also
Work with Data in the Results Pane (Visual Database Tools)
Perform Basic Operations with Queries (Visual Database Tools)