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 derfloh 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
Joined
Mar 20, 2006
Messages
380
Location
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 Question
sql server script error
Replies
0
Views
1K
diembi
diembi
peac3
  • Locked
  • Question Question
Convert data structure
Replies
18
Views
2K
peac3
peac3
xarzu
  • Locked
  • Question 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
2K
xarzu
xarzu
hoangluc19
  • Locked
  • Question Question
Create gridview meeting room and meeting time
Replies
2
Views
2K
SkipVought
S
NoCoolHandle
  • Locked
  • Question Question
working with SQL "FOR JSON AUTO
Replies
2
Views
1K
NoCoolHandle
NoCoolHandle

Part and Inventory Search

Sponsor

Back
Top