sql server mseq: Is it possible to do updates to a grid result from the
query analyzer?

i.e. select * from ABCD gives a grid result (w/ PK cols),
can I edit one or more fields in the gride and update ?

The help files seem to indicate that it is possible
("Rules for Updating Results"), but I seem to be missing
something.

Regards,
Bruce H

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