Skip to Content

Sample SQL script to create "insert....location" command

Following sample script can be used to generate "insert...location" command

The "creator" is the owner of table(s)  , value 1 is for DBA


select 'insert into  ' + T.[table_name] + '_new location' + ' YOUR_SERVER_NAME_LOCATION select * from ' + T.[table_name]  + char(


13) + 'go'


from systab T


where T.creator = 1

Former Member