Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

open table in SQl 2005 Expand / Collapse
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



Group: General Forum Members
Last Login: 2 days ago @ 5:18 AM
Points: 45,619, Visits: 44,147
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, MVP, M.Sc (Comp Sci)
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