wuan的专栏

--from zjcxc(邹建) @csdn--经过修改--使用动态的SQL语句declare @s nvarchar(4000)declare @sql nvarchar(4000)set @s=select @s=case a.name when id then @s else @s+,[+a.name+]endfrom mytmp01.dbo.syscolumns a,m

--生成测试数据------------以‘,’为分隔符select * into #efrom (select 001[id],aaa,bbb,ccc[strall] union allselect 002,bbb,ccc ) a---------------------declare @s intdeclare @p varchar(50) --分隔符set @p=,

先来邹建大大的--下面是测试--测试数据declare @t table(列1 varchar(10))insert into @tselect aunion all select dunion all select eunion all select tunion all select sunion all select 5union all select 96

use tempdbBEGIN TRANSACTION insert into tbl_tmp1(cdate) values(2005-1-2)insert into tbl_tmp1(cdate) values(2005-1-3)insert into tbl_tmp1(cdate) values(2005-1-51)IF (@@error BEGIN  ROLLBACK TRA

http://community.youkuaiyun.com/Expert/topic/3752/3752955.xml?temp=.3692591创建记录--create table t(id numeric,class varchar(50))--delete tdeclare @i numericset @i=0while @ibegin set @i=@i+1insert into t(id,c

declare @sql nvarchar(4000)if @sortName = set @sortName= CommodityTypeIdif @sortType = set @sortType = Ascset @sql=select *,Alltypename=dbo.f_fullname(commoditytypeid) from t_INSMCommodityTyp

declare @list nvarchar(1000)set @list = 456456Test2814557616,456456Test6005645184declare @num int,        @sqls nvarchar(4000)set @sqls=select @a=sum(iCash)from (select substring(cardid,7,4