October 23, 2008 at 9:03 am
Is there a good way to export the data in a table to an SQL Insert statement without using third-party software? I've found a few programs that will do this, but our organization doesn't allow freeware/shareware, so I need a Microsoft tool or something similar to accomplish this.
Ideally, if there's a way to make SQL Management Studio do this, that would be great.
Thanks,
- Brad
SQL Server 2005 or SQL Express
October 23, 2008 at 9:19 am
Hi,
i use this attached stored procdure to generate insert statements then save them from the query result to an .sql inserts file..
October 23, 2008 at 9:57 am
Sherif: Nice sProc! You should contribute this to the SQLServerCentral.com Scripts.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 23, 2008 at 3:41 pm
That's perfect. Thanks!
October 23, 2008 at 3:45 pm
It occurs to me that this could be the perfect tool for posters who want to provide sample data to us for their questions.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 23, 2008 at 4:29 pm
Barry, if you check Narayana Vyas Kondreddi website (http://vyaskn.tripod.com you'll see that is the exact reason this was created.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 24, 2008 at 7:49 am
Fortunately I can install and use SSMS Tools Pack (for 2005 and 2008), which generates the INSERT statements for me
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply