Re: Update query analyzer grid results?

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 08/11/04 

Date: Wed, 11 Aug 2004 08:04:46 +0530

hi bruce,

Not possible with the resultset of query analyzer. Use INSERT or UPDATE
queries against the tables.

In SQL Server 2000 Query analyzer you can perform modification
(insert/update/delete) on the object using browser itself,Press F8 key in
query analyzer to open object browser .

Once you open the browser go to the required table ,right click and select
open. Once you open the table it will show you resultset in right hand side
pane.
(you need to have pk/unique key on the table to do this.)

Using Enterprise manager; right-click the table in Enterprise Manager,
select Open Table, you will see grid of rows.here you can edit the data in
the grid. Once you click on "Run" button it will save the changes. 

-- 
Vishal Parkar
vgparkar@yahoo.co.in | vgparkar@hotmail.com