distal-attribute
distal-attribute
distal-attribute
distal-attribute

update multiple columns is error

User, date Message
gzyou2003 Written by gzyou2003
11 months ago
Category: General
14 posts since Mon, 03 Jun 13
I am modify(or add) two or more columns, click the "Save" error
ansgar Written by ansgar
11 months ago
5098 posts since Fri, 07 Apr 06
What error?
gzyou2003 Written by gzyou2003
11 months ago
14 posts since Mon, 03 Jun 13
my server is sql server2008.
error:
Incorrect syntax near ','.

in 'ALTER code' tab is 'ALTER TABLE "dbo"."test_table"
ALTER COLUMN "a1" VARCHAR(501) NULL,
ALTER COLUMN "b1" VARCHAR(501) NULL;'
gzyou2003 Written by gzyou2003
11 months ago
14 posts since Mon, 03 Jun 13
'ALTER TABLE "dbo"."test_table"
ALTER COLUMN "b1" VARCHAR(501) NULL;' is ok.
gzyou2003 Written by gzyou2003
11 months ago
14 posts since Mon, 03 Jun 13
update one column is ok.
 

Please login to leave a reply, or register at first.