摘要： CREATE FUNCTION [dbo].[Split]( @String VARCHAR(MAX), @Delimiter VARCHAR(5))RETURNS @SplittedValues TABLE( OccurenceId SMALLINT IDENTITY(1,1), SplitValue VARCHAR(MAX))ASBEGIN DECLARE @SplitLength INT W... 阅读全文

摘要： Declare @Id NVARCHAR(36)Declare @Name NVARCHAR(36)DECLARE cur CURSOR FORSELECT Id,Name FROM TABLEOPEN curFETCH next FROM cur INTO @Id,@NameWHILE @@FETCH_STATUS = 0 BEGIN PRINT @Id + @Name FETCH next... 阅读全文