时间累加去除非工作时间
--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...
查询数据库连接数
/* 查询某个数据库的当前连接数*/
select * from master.dbo.sysprocesses
where dbid = DB_ID('XFPDM') order by login_time
/* 查询某个数据库用户的连接情况*/
sp_who 'sa'
/* 查看数据库允许的最大连接*/
select @@MAX_CONNECTIONS...
绩效系统报表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...
根据表面查询主键名
SELECT syscolumns.name
FROM syscolumns,sysobjects,sysindexes,sysindexkeys
WHERE syscolumns.id = object_id('PDM_RouteDetail') AND sysobjects.xtype = 'PK'
AND sysobjects.parent_obj =...
常用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）把查询到的满足条件多行的某列的值组合在一起，并用...
杰
