Script Table Data with TSQL

These INSERTS can be executed to regenerate the data at some other location. This procedure is also useful to create a database setup, where in you can script your data along with your table definitions.

 -- Script all records from the drugcard rule table
EXEC sp_generate_inserts
@table_name = 'rule_med_drugcard' 
-- Script all active records from the drugcard rule table
EXEC sp_generate_inserts
@table_name = 'rule_med_drugcard',
@from = 'FROM dbo.rule_med_drugcard WHERE active = 1'

 

Download here
Instructions and more

Kommentare sind geschlossen

Posts

Tags