update multiple columns is error

[expired user #6988]'s profile image [expired user #6988] posted 10 years ago in General Permalink
I am modify(or add) two or more columns, click the "Save" error
ansgar's profile image ansgar posted 10 years ago Permalink
What error?
[expired user #6988]'s profile image [expired user #6988] posted 10 years ago Permalink
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;'
[expired user #6988]'s profile image [expired user #6988] posted 10 years ago Permalink
'ALTER TABLE "dbo"."test_table"
ALTER COLUMN "b1" VARCHAR(501) NULL;' is ok.
[expired user #6988]'s profile image [expired user #6988] posted 10 years ago Permalink
update one column is ok.

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