如何在T-SQL 2008字符串污染中替换表变量
||
我有一个在SQL 2000中运行的UDF，该UDF使用表var从几行数据中返回以逗号分隔的字符串：
CREATE FUNCTION [dbo].[ReturnVisitsTaskNos]
( @MainlinePlanID int )
RETURNS varchar(1000)
AS
BEGIN
DECLARE @TaskNoTable table
( TaskNo varchar (15) )
DECLARE @TaskList varchar(1000)
SET @TaskList = \'\'
INSERT INTO @TaskNoTable
SELECT TaskNo
FROM MainlinePlanTask
WHERE MainlinePlanID = @MainlinePlanID
IF @@ROWCOUNT > 0
UPDATE @TaskNoTable
SET @TaskList = ( @TaskList + TaskNo + \', \' )
RETURN substring( @TaskList, 1, ( len( @TaskList ) - 1 ))
END
没有找到相关结果
已邀请:
2 个回复
物崎巩
SELECT STUFF( ( SELECT \' \' + Description FROM dbo.Brands FOR XML PATH(\'\') ), 1, 1, \'\' ) As concatenated_stringCREATE FUNCTION [dbo].[ReturnVisitsTaskNos] ( @MainlinePlanID int ) RETURNS varchar(1000) AS BEGIN RETURN SELECT STUFF(( SELECT TaskNo + \', \' FROM MainlinePlanTask WHERE MainlinePlanID = @MainlinePlanID FOR XML PATH(\'\') ), 1, 0, \'\' ) As concatenated_string END磋判粗惊
CREATE FUNCTION [dbo].[ReturnVisitsTaskNos] ( @MainlinePlanID int ) RETURNS varchar(1000) AS BEGIN DECLARE @TaskList varchar(1000) SET @TaskList = \'\' SELECT @TaskList = ( @TaskList + TaskNo + \', \' ) FROM MainlinePlanTask WHERE MainlinePlanID = @MainlinePlanID RETURN substring( @TaskList, 1, ( len( @TaskList ) - 1 )) END