Sql - 随笔分类 - wakaka_wka

SQLite 建表语句

摘要：-- 获取当前日期时间（本地时间） CREATE TABLE Logs ( Id INTEGER PRIMARY KEY AUTOINCREMENT, Message TEXT NOT NULL, LogTime DATETIME DEFAULT (datetime('now', 'localtim 阅读全文

posted @ 2025-11-11 14:04 wakaka_wka 阅读(22) 评论(0) 推荐(0)

SQL 获取某个作业的最近一次执行时间

摘要：SELECT J.name AS JobName, CASE WHEN SJ.last_run_time = 0 THEN NULL ELSE STUFF(STUFF(RIGHT('000000' + CAST(SJ.last_run_time AS VARCHAR(6)), 6), 3, 0, ' 阅读全文

posted @ 2025-07-30 17:23 wakaka_wka 阅读(6) 评论(0) 推荐(0)

SQL 过滤索引

摘要：CREATE UNIQUE INDEX _Idx_FLT_OuterIid ON T_Item(OuterIid) WHERE OuterIid IS NOT NULL AND OuterIid <> '' 阅读全文

posted @ 2025-06-25 08:57 wakaka_wka 阅读(7) 评论(0) 推荐(0)

Sql Server like 区分全半角

摘要：区分全角半角的属性区分全角半角COLLATE Chinese_PRC_CI_AS_WS 区分全角半角区分大小写和全角半角COLLATE Chinese_PRC_CS_AS_WS 区分大小写和全角半角阅读全文

posted @ 2025-01-19 18:49 wakaka_wka 阅读(52) 评论(0) 推荐(0)

SQL Server 查看表占用空间大小

摘要：SELECT db_name() as DbName, t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, CAST(ROUND(((SUM(a 阅读全文

posted @ 2024-10-25 14:28 wakaka_wka 阅读(271) 评论(0) 推荐(0)

SQL 查看CPU消耗最多的10个语句

摘要：--详细版,查看CPU消耗最多的10个语句 SELECT TOP 10 [cpu_time], [session_id], [request_id], [start_time] AS '开始时间', [status] AS '状态', [command] AS '命令', dest.[text] A 阅读全文

posted @ 2024-10-08 09:07 wakaka_wka 阅读(182) 评论(0) 推荐(0)

SQL Server MD5

摘要：SELECT HASHBYTES('MD5', '输入字符串') SELECT CONVERT(VARCHAR(32), HASHBYTES('MD5', '输入字符串'), 2) 阅读全文

posted @ 2024-04-23 17:23 wakaka_wka 阅读(42) 评论(0) 推荐(0)

SQL Server TempDb迁移

摘要：1.查询当前信息： select name,physical_name from sys.master_files where database_id=db_id('tempdb')2.更改位置 ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, F 阅读全文

posted @ 2023-10-04 09:32 wakaka_wka 阅读(169) 评论(0) 推荐(0)

SQL 日期区间重叠判断

摘要：yyyy-MM-dd HH:mm:ss格式的数据, 多用于判断预约时间和每日排班冲突.对于冲突的情况使用列举法有（前提：s<e, s'<e') s' < e' < s < e: 新时间段在已有时间左边, 不包含, 情况1 s' < s < e' < e: 新时间段和已有时间左边有交集, 情况2 s 阅读全文

posted @ 2023-09-22 02:37 wakaka_wka 阅读(553) 评论(0) 推荐(0)

查看sql server数据库连接情况

摘要：SELECT * FROM [Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT [DBID] FROM [Master].[dbo].[SYSDATABASES] WHERE NAME='你的数据库名称' ) 系统存储过程 SP_WHO 提供阅读全文

posted @ 2023-07-08 09:31 wakaka_wka 阅读(228) 评论(0) 推荐(0)

获取存储过程参数信息

摘要：select * from syscolumns where ID in (SELECT id FROM sysobjects as a WHERE OBJECTPROPERTY(id, N'IsProcedure') = 1 and id = object_id(N'[dbo].[你的存储过程名] 阅读全文

posted @ 2022-08-19 18:53 wakaka_wka 阅读(43) 评论(0) 推荐(0)

SQL Server 计算经纬度直线距离

摘要：declare @Lng decimal(18,6)=114.059920--经度declare @Lat decimal(18,6)=22.544884--纬度 declare @GPSLng decimal(18,6)=114.056300--经度declare @GPSLat decimal( 阅读全文

posted @ 2022-04-15 23:23 wakaka_wka 阅读(301) 评论(0) 推荐(0)

SQL Server For XML 字段内容拼接

摘要：declare @tb table(F1 nvarchar(50),Gp nvarchar(50))insert into @tb(F1,Gp)select 'a','A' union select 'a1','A' union select 'b','B' union select 'c1','c 阅读全文

posted @ 2022-03-29 15:58 wakaka_wka 阅读(185) 评论(0) 推荐(0)

SQL Server 查看表数据行数

摘要：SELECT a.name, b.rows FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id WHERE (a.type = 'u') AND (b.indid IN (0, 1)) ORDER BY b.rows DESC 阅读全文

posted @ 2022-02-21 14:07 wakaka_wka 阅读(727) 评论(0) 推荐(0)

获取所有包含指定字段的所有表

摘要：with t1 as(Select Name as TblName,Object_Id(Name)TblObjId FROM SysObjects Where XType='U' ),t2 as(select a.*,b.name as ColName from t1 a join SysColum 阅读全文

posted @ 2020-10-27 16:57 wakaka_wka 阅读(93) 评论(0) 推荐(0)

Sql 获取满足给定汇总值的前N条记录

摘要：1 declare @ivt table(Qty int,Code nvarchar(10)) 2 insert into @ivt(Qty,Code) 3 select 7,'a' union 4 select 3,'b' union 5 select 4,'c' 6 select * from 阅读全文

posted @ 2020-03-25 02:41 wakaka_wka 阅读(281) 评论(0) 推荐(0)

随笔分类 - Sql