SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Script Library
 Generate INSERT statements...
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

X002548
Not Just a Number

15586 Posts

Posted - 01/30/2006 :  09:54:04  Show Profile  Reply with Quote
Talk about a long life....

Or you can just do a dump and restore



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page

TimS
Posting Yak Master

USA
198 Posts

Posted - 01/30/2006 :  16:35:58  Show Profile  Reply with Quote
Have you looked at http://vyaskn.tripod.com for sp_generate_inserts the link below goes direct to it.
http://vyaskn.tripod.com/code.htm#inserts

Tim S
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/24/2006 :  03:48:39  Show Profile  Reply with Quote
This may also be useful:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73884
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30214 Posts

Posted - 10/24/2006 :  03:51:21  Show Profile  Visit SwePeso's Homepage  Reply with Quote
And this maybe? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73608


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22754 Posts

Posted - 10/24/2006 :  05:48:00  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote

http://sqlteam.com/forums/topic.asp?TOPIC_ID=53420

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 10/24/2006 :  13:54:40  Show Profile  Reply with Quote
what brought this up again?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/24/2006 :  14:09:52  Show Profile  Reply with Quote
"what brought this up again?"

Some links came up on new threads and I thought it would be worth "upgrading" this thread as it features in the FAQ and high on Googles hit-list

Kristen
Go to Top of Page

Optillect
Starting Member

2 Posts

Posted - 04/12/2011 :  16:35:50  Show Profile  Reply with Quote
unspammed
Go to Top of Page

sushil.thakur76
Starting Member

India
3 Posts

Posted - 04/13/2011 :  02:51:19  Show Profile  Reply with Quote
select
@cols = coalesce(@collist + ',','') + column_name
from
information_schema.columns
where
table_name = @table


susheel
Go to Top of Page

Idyana
Yak Posting Veteran

95 Posts

Posted - 07/25/2011 :  09:08:05  Show Profile  Reply with Quote
tq sir
Go to Top of Page

neeraj_sharma
Starting Member

India
15 Posts

Posted - 10/24/2012 :  01:09:20  Show Profile  Reply with Quote

for that i made a store procudure for that .

http://sql-server-script.blogspot.in/



@nrj
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000