I want to know how can i update computed columns
CREATE TABLE [dbo].[Test1](
[id] [int] IDENTITY(1,1) NOT NULL,
[invoiceno] AS ('AMC'+right('000000'+CONVERT([varchar](20),[id],0),(9))),
[PersonID] [int] NULL,
[Unit] [varchar](10) NULL
) ON [PRIMARY]
This is the script of my table , i want to update the invoice acc to the condition, please help me
Thanks in advance
...
Go to the complete details ...