2011年1月14日
摘要: 1)检查指定的当前标识值 DBCC CHECKIDENT select MAX(Id) from [Table]xxx = MAX(Id)dbcc checkident('Table',Reseed,xxx)2)with as ALTER FUNCTION [dbo].[fn_Cte_Split_Inline]( @list nvarchar(MAX), @delim nchar(1) = ',') RETURNS TABLE AS RETURN WITH csvtbl(debut, fin) AS ( SELECT debut = convert(bigint 阅读全文
posted @ 2011-01-14 16:50 鱼不爱水 阅读(251) 评论(0) 推荐(0)