sql server create insert script from table data

When data_type = 'uniqueidentifier' THEN 'CASE WHEN IS NULL THEN ''NULL'' ELSE ''''''''+CONVERT(NVARCHAR(MAX),)+'''''''' END ' Join syscolumns co on co.name=c.COLUMN_NAME and object_name(co.id)=so.name and OBJECT_NAME(co.id)=c.TABLE_NAME and co.id=so.object_id and c.TABLE_SCHEMA=SCHEMA_NAME(so.schema_id) Join sys.tables ta on ta.object_id=so.object_id select distinct 'SELECT ''INSERT INTO ' + schema_name(ta.schema_id) + '.' + so.name + ' (' + substring(o.list, 1, len(o.list)-1) + ') VALUES ('

It generates 'SELECT' statements that you can then run on the tables to generate the 'INSERT' statements. SELECT 'Select +'FRom ' With(NOLOCK) ' + ' Where to share, I've developed my own script to do it.

SELECT INTO Row_number()Over (Order by ORDINAL_POSITION ), Column_Name , table (Row_number SmallINT, Column_Name VArchar(Max) ) Here Dbo is schema and test is tablename and 1=1 is condition 'Dbo.test where name =''neeraj''' * for string (2) Here dbo is schema and test is tablename and name='neeraj' is condition.Īuthore : neeraj prasad sharma (please dont remove this :))Įxample (1) Exec. (1) Here dbo is schema and test is tablename and 1=1 is condition. I tried to find this kind of stuff for a while but wasn't satisfied with the results, so I wrote this stored procedure.Įxample: Exec.

This is a stored procedure which you need to run once and then it is tailor made for you. This script generates insert statements of your existing data.

Sql server create insert script from table data