摘要:
declare @str varchar(200) set @str='' -- 必须先赋值 select @str=@str+cast(tb.[objid] as varchar(10))+',' from( select [objid],sfrq from tablename ) tb order by tb.sfrq print @str 阅读全文
摘要:
alter proc ljgl_cp_yzzx @usetag int ,@ids varchar(1000) as begin begin tran tr1 select * into #temp from fn_split(@ids,',') update cp_advice set usetag=@usetag where [objid] in (select * from... 阅读全文