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 |
|
allan8964
Posting Yak Master
249 Posts |
 Posted - 2012-01-26 : 16:36:55
|
| hi there,We know we can use "script table as" feature to dump the sql script for a table. Is there any way to get the table content with script as "insert into tablename (...) values (...);"? Thanks. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-01-26 : 16:47:33
|
you can google for: sql server insert script generatoror use this: http://www.ssmstoolspack.com/
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-26 : 18:17:38
|
| its possible using generate script wizard in sql 2008------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
allan8964
Posting Yak Master
249 Posts |
Posted - 2012-01-28 : 22:51:56
|
| Got the software, here is a link http://stackoverflow.com/questions/982568/what-is-the-best-way-to-auto-generate-insert-statements-for-a-sql-server-table to that feature in sql.thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-29 : 14:13:00
|
| whats the problem with generate script wizard available in SSMS?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2012-01-30 : 08:32:14
|
| I tihnk that link is the instructions for how to use that feature (as the options, to activate it, are rather "hidden" in SSMS) |
|
|
|
|
|
|
script table with data