ringliwei

虚拟数字辅助表概念来源于《Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions》 代码如下：GO/****** Object: UserDefinedFunction [dbo].[GetNums] Script Date: 2018/5/25 9:20:32 ******/SET ...

SQL字符串Split直接看代码：GO/****** Object: UserDefinedFunction [dbo].[StringSplit] Script Date: 2018/5/25 9:38:32 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE FUNCTION [dbo].[St...

根据文本查找存储过程代码：SELECT A.name FROM sys.sysobjects A JOIN sys.syscomments B ON A.id=B.idWHERE A.xtype='P' AND B.text LIKE '%TEXT%'说明： 将Text替换为想要查找的内容即可。...

脚本生成SQL Server表的POCO对象 偶然在网上看到下面这个法子。代码：SELECT DATA_TYPE, CONCAT('public ', CASE WHEN DATA_TYPE = 'int' THEN 'int' WHEN DATA_TYPE = 'tinyint' THEN 'byte' W...

SQL Server重置IDENTITY属性种子值-- IDENTITY重置种子DBCC CHECKIDENT(表名, RESEED, 0)

SQL Server确定统计边界 一些统计任务需要根据当前日期确定统计的边界：天或月代码：GO-- DATEADD, DATEDIFF, Statistics, 日期范围DECLARE @StatisticsDay DATETIME='2018-05-03'DECLARE @StatisticsTodayStartTime DATETIME -- 要统计的日期上边界D...

DECLARE @BackDate nvarchar(50) =replace(replace(replace(convert(varchar,getdate(),20),'-',''),' ',''),':','')SELECT 'backup database '+name+' to disk=''F:\backup\'+name+'\'+name+'_'+@BackDate+'.bak''...