你要写什么呀? select 就是选择和赋值的,你可以得到@Var后,在判断一下 if @Var= ?? insert into .....
谢谢上面的,我想实现如果字符串长度大于2000时自动插入到数据库中,并重置为空。我的理想语句为: select @var = case when len(@var) > 2000 then insert into ##(keystr) values ($var+cast(field as varchar)) set $var = '' else @var + cast(field as varchar) end from tbl
insert into ##(keystr) select (when len(field) > 2000 then @var else ... end)可以这样
insert into ##(keystr) select (case when len(field) > 2000 then @var else ... end)
select 就是选择和赋值的,你可以得到@Var后,在判断一下
if @Var= ??
insert into .....
select @var = case
when len(@var) > 2000 then
insert into ##(keystr) values ($var+cast(field as varchar))
set $var = ''
else
@var + cast(field as varchar)
end from tbl
insert into ##(keystr) select (case when len(field) > 2000 then @var else ... end)