Query for Getting insert scripts of the Table's Data
Posted by
Arunjith under
Sql Server on 6/12/2012 5:24:32 AM |
Points: 75 | Views : 5099 | Status :
[Member]
SELECT *, 'INSERT INTO db_name.[dbo].tbl_name VALUES('''+ CAST([column_1] AS VARCHAR) + ''', '''+ CAST(column_2
AS VARCHAR)+ ''', '''+ CAST(column_3 AS VARCHAR)+ ''')' FROM
db_name.[dbo].tbl_name