OK I did there is a name in there name(sysname(nvarchar(128)),null)

I need to insert zero to every column except the first one which contains primary key.

thanks

Ok I don't understand the first line of code select '[' + name + '] = 0,'

name I think is a column name?

This is what I have , still no Zeros in the columns

select '[' + name + '] = 0'

from sys.columns

WHERE object_id = OBJECT_ID(N'[dbo].[ArCustomerBal]')

and name != ' @sx_customer_code'

table design arcustomer

[Customer] [char](7) NOT NULL,

[Name] [char](30) NULL,

[ExemptFinChg] [char](1) NULL,

[Salesperson] [char](3) NULL,

[CustomerClass] [char](2) NULL,

[Salesperson,] [char](2) NULL,

[TermsCode] [char](2) NULL,

[Area] [char](2) NULL,

[Branch] [char](2) NULL

two...