Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dr223
Constraint Violating Yak Guru
444 Posts |
 Posted - 2013-06-10 : 06:36:52
|
| Hi, I have SQL Server 2008 installed on my PC. I have always been working with 2005.. Two things that need help:a) Is there a way I can remove the entire query /******* Script for SelectTopNRows command from SSMS***/ Select Top 1000...... ..... I just want to see the table fields on the page and not the select statement in top.b) It ONLY gives the option of open 'SELECT Top 1000 Rows' what if I have 7,000,000 records I want to open? In 2005, I just right click on the table and choose Open Table.. Any help will be highly appreciated.. Thank you |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-06-10 : 07:19:32
|
| You can set shortcut keys to display all records..steps to create short cut:Tools in SSMS --> Options --> Environments --> Keyboard --> Under shortcuts --> Type SELECT * FROM under Stored Procedure --> Click on OKThen take New Editor --> Press Ctrl+ShortCutKey--Chandu |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-10 : 07:52:28
|
| Why cant you simply open a new window and type SELECT * FROM table rather than going the GUI route?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
SQl Server 2008 - Open Table