sql server create insert script from table data

#Sql server create insert script from table data code#

These INSERTS can be executed to regenerate the data at some other location. Purpose: To generate INSERT statements from existing data. (Copyright © 2002 Narayana Vyas Kondreddi. Procedure: sp_generate_inserts (Build 22) So, dropping it'ĮXEC _MS_upd_sysobj_category 1ĬREATE PROC varchar(776), - The table/view for which the INSERT statements will be generated using the existing varchar(776) = NULL, - Use this parameter to specify a different table name into which the data will be bit = 1, - Use this parameter to include/ommit column list in the generated INSERT varchar(800) = NULL, - Use this parameter to filter the rows based on a filter condition (using bit = 0, - Specify 1 for this parameter, if you want to include the TIMESTAMP/ROWVERSION column's data in the INSERT bit = 0, - If is set to 1, the SQL statements constructed by this procedure will be printed for later varchar(64) = NULL, - Use this parameter if you are not the owner of the bit = 0, - Use this parameter to generate INSERT statements by omitting the 'image' bit = 0, - Use this parameter to ommit the identity int = NULL, - Use this parameter to generate INSERT statements only for the TOP n varchar(8000) = NULL, - List of columns to be included in the INSERT varchar(8000) = NULL, - List of columns to be excluded from the INSERT bit = 0, - When 1, disables foreign key constraints and enables them after the INSERT bit = 0 - When 1, computed columns will not be included in the INSERT statement IF (SELECT OBJECT_ID('sp_generate_inserts','P')) IS NOT NULL -means, the procedure already exists

PRINT 'Checking for the existence of this procedure'

#Sql server create insert script from table data code#

Source code copied from link: SET NOCOUNT ON You can find the text here.įor example, it lets you do this: EXEC sp_generate_inserts 'titles' We use this stored procedure - it allows you to target specific tables, and use where clauses.