TSQL proc Generate Insert into statements
-
Hello,
Looking to find T-SQL code, stor proc which can be used to run with table name as the parameter.
The script should provide data from the table as
Insert into Table1 (col1, col2, col3) Values ('abc', 'defc', 123)
Had found one called sp_Generate_inserts on vyaskn.tripod.com but the values seem to get truncated ; something like
Insert into Table1 (col1, col2, col3) Values ('abc',
and the table just had 146 rows about 9-10 columns
Any help appreciated
Thank You
Dragon
Melbourne-Australia -
https://github.com/drumsta/sql-generate-insert
This should help
-
Thank You
Dragon
Melbourne-Australia
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply