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

update multiple columns is error

User, date Message
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
Written by ansgar
11 months ago
5045 posts since Fri, 07 Apr 06
What error?
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;'
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.
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.