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

update multiple columns is error

gzyou2003 posted 1 year ago in General
I am modify(or add) two or more columns, click the "Save" error
ansgar posted 1 year ago
What error?
gzyou2003 posted 1 year ago
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 posted 1 year ago
'ALTER TABLE "dbo"."test_table"
ALTER COLUMN "b1" VARCHAR(501) NULL;' is ok.
gzyou2003 posted 1 year ago
update one column is ok.

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