laihua的专栏

--************--在两个日期范围里所跨越那几周返回如：1，2表是第一周和第二周，declare @aa table (date datetime,weekdays int )   declare @i int    set @i=datediff(day,@bdate,@edate)    while(@i>=0)    begin    insert @aa    values (

alter proc prc_num @num bigintasdeclare @numstr varchar(50)set @numstr=while (@numbegin   set @numstr=@numstr+convert(char(1),@num%2)   set @num=@num/2endselect reverse(@numstr)exec prc_num 8

declare   @ProID bigintselect  @ProID=id from sysobjects where  type=p and name=@SP_Nameselect a.name N参数名 ,COLUMNPROPERTY(@ProID,a.name,PRECISION) as N长度,a.length N占用字节数,a.isoutparam N是否输入