Posted - 08/15/2012 : 11:22:19
| Hi all,
I am new in SQL, so my problem is trivial. I try edit table:
aalter TABLE [dbo].[pasta](
[derectives] [int] NULL,
[sample] [nchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[db] [real] NULL,
[surename] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[result] AS ([sample]+[surename])
[capor] as ([derectives]*10)
) ON [PRIMARY]
And all the time get error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '('.
Could you advise that is wrong???