Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 sql server management studio question.

Author  Topic 

csphard
Posting Yak Master

113 Posts

Posted - 2014-04-29 : 07:15:38
In older versions using query analyzer we can query the database and update the data without using an update statement. The window that displays your information is a result window and I guess therefore not updateable.

Can anyone explain if it is still possible to query a table and update the data manually? and if so how

Howard

Tusharp86
Starting Member

9 Posts

Posted - 2014-04-29 : 07:31:25
1.right click on table
2. Select Edit top ... Records
3. Click on "Show SQL Pane"

It will open the new query window with result grid
Go to Top of Page

csphard
Posting Yak Master

113 Posts

Posted - 2014-04-29 : 07:50:33
Thanks... That worked.
Go to Top of Page
   

- Advertisement -