Luck.Zhang_LA

insert into order_info(sourceid,ordertypeid,packnum,statusid,intime,isneworder)select 1,58,1,6,GETDATE(),1 union allselect 1,58,1,6,GETDATE(),1

1使用outer apply统计查询select * from(select COUNT(1) 'all' from t_smsphone where sendtime>='2014-01-01 18:26:04.803' and sendtimeouter apply(select COUNT(1) 'succ' from t_smsphone where flag=1 and

if not exists(select   1   from   syscolumns   where   id=object_id('source_wait')   and   name='sort'  )beginalter table source_wait add  sort  int not null default 0endgo

declare @i intdeclare @sourceid int declare @tempid intset @sourceid=0--循环变量set @i=0while @ibegin--订单快递id为动态变量set @tempid=( select top 1 tid from sys_typelib where tpid=1 and tid>@so

1.查询表里加一列自动编号.例如下面的rowid2.查询A表列+B表一聚合列。例如下面的sumnumdemo:SELECT ROW_NUMBER() OVER(ORDER BY u.ID DESC) AS Rowid,u.ID,u.UserName,u.TrueName,u.JoinNum,(SELECT COUNT(1) FROM erp_MeetingAttendanc

时间的分钟-->就是将 时间转换成 fen