create table test000(id int identity(1,1),col nvarchar(10))
insert into test000 select 'A' union all select 'A' union all select 'A' union all select 'A' union all select 'A' union all
select 'B' union all
select 'C'
update test000
set col='CC'
from test000
where id>5select * from test000update test000
set col='AA'
from test000
where id<5select * from test000drop table test000
insert into test000 select 'A' union all select 'A' union all select 'A' union all select 'A' union all select 'A' union all
select 'B' union all
select 'C'
update test000
set col='CC'
from test000
where id>5select * from test000update test000
set col='AA'
from test000
where id<5select * from test000drop table test000
SET f_smg_level = 2
WHERE F_ID < 10030
SET f_smg_level = 2
WHERE (F_ID < 10030)
请问各位同行这是什么原因啊??????!!!!
------------------應該不是上面的update 語句有問題 吧
upadte T_SMG_POST_LIST
SET f_smg_level = 2
WHERE (F_ID < 10030)
是沒有錯的
把整个语句贴出来.
系统报 行 2: '=' の近くに無効な構文があります。
这个错 哈哈