SQL游标用法
if OBJECT_ID('tempdb..#xxxx') is not null
drop table #xxxx
select (select count(*) from PDM_salesOrderDT2 where Doccode = w.refdoccode) as digit,0 as ti,
w.PrDtDate,w.DelDate,null ...
sql group by、case when用法举例
select
txtmemo,
count(*) as [总计],
sum(case
when w1.status = 6 then 1
else 0
end) as [已完成],
sum(case
...
跨服务器SQL语句执行
--exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','IP地址'
--exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa','数据库密码'
select formid from srv_lnk.QxbtXH.dbo.nw_gform
--insert ...
时间累加去除非工作时间
--select top(50) * from PDM_WOMFGOrder order by enterdate desc
--select dateadd(second,2*60*60,'2020-01-06 12:10:13.577')
create function dateAddWork (@datex datetime,@t int)
retu...
绩效系统报表sql语句
select companyname, * from PDM_SalesOrderHD where docdate between '2020-05-01' and '2020-06-01' order by docdate desc
--统计各个分厂在某个时间段内的画图总数
select b.companyname,count(*) as di...
常用sql代码
1）复制table1到table2，要求table,2表存在
Insert into Table2(a, c, d) select a,c,5 from Table1
2）把test1表的所有数据复制到test2表（要求test2表不存在)
select * into test2 from test1
3）把查询到的满足条件多行的某列的值组合在一起，并用...
杰
