July 13, 2009 at 8:13 am
Hi,
I have just installed SQL 2008 and I'm trying to get use to some of the new features. One thing I cannot seem to figure out is where the navigation options are for the results pane. When I run a query and it produces the results, there are not forward, back or goto end buttons. Also, I am not able to key in a new record to the pane at the end of the dataset like I used to with 2005.
I have looked through the options on the menus to see if something is not turned on but to no avail.
Any help would be appreciated.
July 13, 2009 at 10:39 am
Are you speaking of SSMS?
I wasn't aware that you could type a new record in the results, and I wouldn't be sure this is a good idea.
This is a query window, not an editing pane. You don't have a real time list of the table, you have a result set from that point in time.
July 13, 2009 at 12:06 pm
I am talking about Management Studio for SQL 2008.
I have discovered that if you right click on a table and select edit top 200 rows option, then you get navigation and the ability to add a new record in the results pane based on a query (which is editable).
If however you select the new query button from the toolbar and run a query that returns a data to the results pane you do not get the navigation or add new record capability.
I agree that it is not good practice to be keying in data in a query results window. However from a testing standpoint and analyzing data results it can be very handy in the right situation.
Thanks
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply