I need to write a Stored Procedure for SQL Server 2008 with function to copy a record from table to the same table with change only the primary key /Int/ . So I’m curious do I have option to avoid explicitly describe the fields with T-SQL ? It will be faster (actually I need this solution for 6 tables), but also if I add a addition filed in the table it will be good to avoid the need to fix this (these) stored procedures .. In C# this could be done with loop via Fields collection, so I need equal functions but in T-SQL
Logically, the function for my user will be to copy a old campaign in new one and then to edit this new one campaign. A campaign is consist of these 6 tables relative records.