随笔分类 -  sqlserver

sqlserver根据哈希算法生成类似uuid字符串
摘要：select STUFF(STUFF(STUFF(STUFF(CONVERT(NVARCHAR(32), HASHBYTES('SHA2_256','固定字符串'), 2), 9, 0, '-'), 14, 0, '-'), 19, 0, '-'), 24, 0, '-')36位 select RI 阅读全文
posted @ 2024-04-09 21:05 半、枫 阅读(89) 评论(0) 推荐(0)
查询表字段说明(存储过程)
摘要：USE [Inroad]GO /****** Object: StoredProcedure [dbo].[Help_TableColumn] Script Date: 2023/1/31 17:39:28 ******/SET ANSI_NULLS ONGO SET QUOTED_IDENTIFI 阅读全文
posted @ 2023-01-31 17:46 半、枫 阅读(36) 评论(0) 推荐(0)
把一对多的数据合并成一条
摘要：1、使用for xm path select a.c_id,(select [value] = stuff((select ','+max(checkcontent) from RiskControlEvaluateUnitRecordAnalysisRelationRequire detail w 阅读全文
posted @ 2022-08-17 22:31 半、枫 阅读(66) 评论(0) 推荐(0)
使用OUTER APPLY处理左连接数据
摘要：select count(*) from SafeInspectionPlanRecord s --安全巡查记录 OUTER APPLY( SELECT TOP 1 * FROM safeInspectionplanrecordpointunititem WHERE recordid =s.c_id 阅读全文
posted @ 2022-08-05 00:08 半、枫 阅读(39) 评论(0) 推荐(0)
sqlserver 查看表死锁
摘要：SELECT request_session_id spid,OBJECT_NAME(resource_associated_entity_id) CommonLedgerConfigPartColumnRecord FROM sys.dm_tran_locksWHERE resource_type 阅读全文
posted @ 2022-08-01 23:35 半、枫 阅读(186) 评论(0) 推荐(0)