将相同类型的书名拼接起来(大概是这个意思)
USE [MTEMP]
GO
/****** Object: UserDefinedFunction [dbo].[GS] Script Date: 11/18/2013 12:19:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[GS](@Id INT)
RETURNS NVARCHAR(4000)
AS
BEGIN
DECLARE @SNames NVARCHAR(4000)
SET @SNames = ''
SELECT @SNames = @SNames+char(10)+History FROM V2 WHERE id = @Id
SET @SNames= STUFF(@SNames,1,1,'')
SET @SNames= '"mailto:'+@SNames+'%22'
RETURN @SNames
END
GO
/****** Object: UserDefinedFunction [dbo].[GS] Script Date: 11/18/2013 12:19:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[GS](@Id INT)
RETURNS NVARCHAR(4000)
AS
BEGIN
DECLARE @SNames NVARCHAR(4000)
SET @SNames = ''
SELECT @SNames = @SNames+char(10)+History FROM V2 WHERE id = @Id
SET @SNames= STUFF(@SNames,1,1,'')
SET @SNames= '"mailto:'+@SNames+'%22'
RETURN @SNames
END