Swap two records excluding few coloums using Stored Procedure in SQl 2000/2005
How to create a Stored procedure (SQL 2005/2000) to swap 2 records excluding few columns, it has to get "table name", "record id (2 id)" and "column to exclude" as a parameter.  Here columns are dynamic as we get 'table' as a parameter and number of columns may be more than 50.  

Here I believe, "update [table name] set [field] = [value] ......"

type statements will be very lengthy as the number of columns will be more than 50 and it is a variant.    

Is there any simple way to Swap records in SQL 2005/2000?


Swap two records excluding few coloums using Stored Procedure in SQl 2000/2005
===

How to create a Stored procedure (SQL 2005/2000) to swap 2 records excluding few columns, it has to get "table name", "record id (2 id)" and "column to exclude" as a parameter.  Here columns are dynamic as we get 'table' as a parameter and number of columns may be more than 50.  

Here I believe, "update [table name] set [field] = [value] ......"

type statements will be very lengthy as the number of columns will be more than 50 and it is a variant.    

Is there any simple way to Swap records in SQL 2005/2000?

