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

update multiple columns is error

User, date Message
Written by gzyou2003
9 months ago
Category: General
14 posts since Mon, 03 Jun 13
I am modify(or add) two or more columns, click the "Save" error
Written by ansgar
9 months ago
4939 posts since Fri, 07 Apr 06
What error?
Written by gzyou2003
9 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;'
Written by gzyou2003
9 months ago
14 posts since Mon, 03 Jun 13
'ALTER TABLE "dbo"."test_table"
ALTER COLUMN "b1" VARCHAR(501) NULL;' is ok.
Written by gzyou2003
9 months ago
14 posts since Mon, 03 Jun 13
update one column is ok.
 

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