将相同类型的书名拼接起来(大概是这个意思)

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
posted @ 2013-11-25 13:45  pnljs  阅读(204)  评论(0编辑  收藏  举报