xiaoye1202的博客

--取消表自增属性ALTER PROC Sp_CancelIdentity@tablename varchar(20), --表名@columnname varchar(20) --自增字段ASDECLARE @sql VARCHAR(4000)SET @sql = 'alter table ' + @tablename + 'add asidentity int update ' + @tablename + ' set asidentity = ' + @columnname +...

Create FUNCTION [dbo].[Split](@SplitString VARCHAR(8000),-- nvarchar(4000)@Separator VARCHAR(2) = ',')RETURNS @SplitStringsTable TABLE([id] INT IDENTITY(1,1),[value] VARCHAR(8000)-- nvarchar(4000))ASBEGIN DECLARE @CurrentIndex INT; ...

CREATE FUNCTION [dbo].[MD5](@src varchar(255),@type int)RETURNS varchar(255)ASBEGIN DECLARE @md5 varchar(34) DECLARE @return varchar(50) SET @md5 = upper(sys.fn_VarBinToHexStr(hashbytes('MD5', @src))); if @type=16 set @md5= S...

create function [dbo].[F_GetPY]( @str nvarchar(4000))RETURNS nvarchar(4000)ASBEGIN declare @word nchar(1),@PY nvarchar(4000) set @PY='' while len(@str)>0 begin set @word=left(@str,1) --如果非汉字字符，返回原字符 s...