Home Forums SQL Server 2005 T-SQL (SS2K5) Append record RE: Append record
rxm119528
SSCrazy
Points: 2960
More actions
August 14, 2014 at 11:30 am
#1738151
Try this. I will not update but generates the script for update columns
select '[' + name + '] = 0'
from sys.columns
WHERE object_id = OBJECT_ID(N'[dbo].[myTable]')
and name != 'CustCode'
Thanks