Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Generate SQL Script to create table and it's data.

Status
Not open for further replies.
robertfah

robertfah

Programmer
Mar 20, 2006
380
US
I need to write a method that will take a table name as a parameter and generate the SQL statement for creating and inserting the data.

What I'm trying to do is copy a table and it's data to another database but I only need the SQL to do so.

Any ideas?
 
Status
Not open for further replies.

Similar threads

diembi
  • Locked
  • Question
sql server script error
Replies
0
Views
617
diembi
diembi
peac3
  • Locked
  • Question
Convert data structure 1
Replies
18
Views
585
peac3
peac3
xarzu
  • Locked
  • Question
What is the proper way to declare a Microsoft class to use in my code. The quick and dirty way I am doing it here, I know, is not correct
Replies
0
Views
550
xarzu
xarzu
hoangluc19
  • Locked
  • Question
Create gridview meeting room and meeting time
Replies
2
Views
834
SkipVought
S
NoCoolHandle
  • Locked
  • Question
working with SQL "FOR JSON AUTO
Replies
2
Views
454
NoCoolHandle
NoCoolHandle

Part and Inventory Search

Sponsor

Back
Top