Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

open table in SQl 2005 Expand / Collapse
Author
Message
Posted Friday, November 15, 2013 1:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 22, 2013 3:12 PM
Points: 3, Visits: 14
my table is having identity column on id .when i open table by using rt click on table open table .Id columns are not in ascending order.Is ther any shortcut key for this without any query
Post #1514845
Posted Saturday, November 16, 2013 2:31 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 42,765, Visits: 35,863
No guarantee of any order. I think with the open table you can click a button at the top to get the query, add the order by and re-run, but to be honest the open table is buggy and probably should be avoided. Use queries.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1514899
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse