How to Create Insert Statement from Table Data using sp_export_data without the Id? I have the following statements and want to omit the Identity. How would I accomplish this?
This is how I'm scripting the one row:
exec sp_export_data tblTableName
, @from ="FROM tblTableName WHERE tblTableNameId = 123"
This is how I am script the whole table:
exec sp_export_data tblTableName
, @from ="FROM tblTableName"
Any & all feedback is appreciated.