>>>>>>>In the SQL Server 2005 Mgt Studio, I can open a table, change data manually, then save the results back to the database. In a was, sort of like a VFP BROWSE statement. I can do this by bringing back all rows from the table, but can I do this be bringing back only certain rows? Note that I want read/write capability, not read-only.
>>>>>>>
>>>>>>>The reason why I ask is that instead of writing a complex UPDATE statment, and possibly making a big mistake, I would like to bring back some rows make the changes manually then write them back... just like I can do with a VFP table and the BROWSE commmand.
>>>>>>
>>>>>>Sure. Just add a WHERE clause to limit the returned records. (stop the returning of all records, and then click the SQL button)
>>>>>
>>>>>Hi Fred!
>>>>>
>>>>>I don't know which TSQL statement to add the WHERE clause to? :-)
>>>>
>>>>Once you "open" your table (and then stop the return of all records), click the SQL button in the upper left. That should get you a TSQL statement already set up for you. Just add your WHERE clause there.
>>>
>>>I apologize! Sorry you had to tell me twice. So the query is different from this other SQL button window thingy. Man, SQL Server isn't half bad. :-)
>>
>>The major thing I don't like about the new SQL window is that you can't do a JOIN of tables and be able to update the record info from the "browse". You could do that with the old SQL (2000) management tool. You can only do one table at a time.
>
>Is there a way to get into that SQL window without having to open the table and stop the pulling back of the data?

Not that I know of. If you open a SQL window, that always asks me for a new connection. I've found it easier to just stop the retrieval.