asked on How do I create SQL Script to create SQL table including Data for SQL 2008
How do I create SQL Script to create SQL table that includes Data for for an existing SQL 2008 Table. I need this to be able to add the script to my Visual Studio 2008 SQL.txt file for when I publish the project, I havelooked all over the MSDN Library and have NOT been able to find what I am looking for, especially since I do not know the terminology.
Microsoft SQL ServerMicrosoft SQL Server 2008
Last Comment
Raja Jegan R
Follow below steps
- execute create table query
- run below query in SQL manager for each table ( convert all numeric fields into varchar )
- copy all result in script file and execute each in the script
- execute create table query
- run below query in SQL manager for each table ( convert all numeric fields into varchar )
- copy all result in script file and execute each in the script
select 'insert into tUser (uId,uName) values ('+convert(varchar,uId)+','+uName+')' from tUser
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Was exactly what I wanted and it actually worked too.
Thanks
ITCS Admin
Thanks
ITCS Admin
Welcome..
create table as select...
Here is an example:
http://www.faqs.org/docs/ppbook/r25329.htm