查询不重复值总数,查询不重复值具体值
查询不重复值总数 select count(distinct lieming ) from table where tiaojian=1 查询不重复值具体值 select distinct lieming from table where tiaojian=1
网事随记
查询不重复值总数 select count(distinct lieming ) from table where tiaojian=1 查询不重复值具体值 select distinct lieming from table where tiaojian=1
删除作业 use [msdb] declare @job_name varchar(100) set @job_name = N'正式库每天凌晨3:00第二次完整备份.Subplan_1' --注:job_name为维护计划对应的job name --删除在计划里面的日志 delete sysmaintplan_log from sysmaintplan_subplans as subplans inner join sysjobs_view as syjobs on subplans.job_id = syjobs.job_id
主库创建用户,获取用户sid select sid from sys.sql_logins where name = 'NAME' 在辅助副本上 create login NAME with password='PASSWOED', sid=SID ------------------------------------------------------ 原库执行,获取sid select [name], sid from syslogins where [name] = 'user'
1、查询所有存储过程的名称以及定义 SELECT name, definition FROM sys.sql_modules AS m INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id WHERE o.[type] = 'P'
SELECT AAA.host_name,BBB.* from Sys.dm_exec_Sessions AS AAA,( SELECT [session_id] , [request_id], [cpu_time], [start_time] AS '开始时间', [status] AS '状态', [command] AS '命令', dest.[text] AS 'sql语句',
V