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 |
|
learning_grsql
Posting Yak Master
230 Posts |
 Posted - 2012-08-08 : 08:29:32
|
| Hi,I have free 2008 sql server management studio.When I right click the table, i don't find see option like "open". but there are options top 1000 rows or something like that.I want to open complete table. is it possible? |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-08-08 : 08:51:23
|
That's not really what management studio is for.How about this:1) Right click on the database2) Select "New Query"3) type the following:SELECT * FROM <TheSchemaName>.<TheTableName>[code]4) in the result set you get right click and select "Copy With Headers"5) Paste into Excel or spreadsheet of choiceI'm assuming you don't want to edit the values? if you want to do that then you probably want to learn how to use the SQL UPDATE statement.Hope that helps.Transact Charlie[code]Msg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. http://nosqlsolution.blogspot.co.uk/ |
 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-08-08 : 08:52:48
|
| Go to Tools -> Options -> SQL Server Object Explorer -> Commands and change the Values there to some very large value. |
|
|
|
learning_grsql
Posting Yak Master
230 Posts |
Posted - 2012-08-08 : 10:27:35
|
| Thanks Charlie & Sunita...now it is clear to me. |
|
|
|
|
|
|
open complete table in server 2008 mgmt studio