关于自定义函数的调用问题,简单
代码为
CREATE FUNCTION QTStrToInt (@QTStr nvarchar(200))
RETURNS INT AS
BEGIN
DECLARE @RESULT INT
DECLARE @POS INT
SET @RESULT = 0
IF LEN(@QTSTR) > 0 AND RIGHT(@QTStr, 1) <> ','
SET @QTStr = @QTStr + ','
WHILE LEN(@QTStr) > 0
BEGIN
SET @POS = CHARINDEX(@QTStr, ',', 1)
SET @RESULT = @RESULT + CAST(LEFT(@QTStr, @POS - 1) as INT)
SET @QTStr = STUFF(@QTStr, 1, @POS, '')
END
RETURN @RESULT
END
我用 SELECT QTStrToINT('33,43,32,32'),错误为:
服务器: 消息 195,级别 15,状态 10,行 1
'QTStrToINT' is not a recognized function name.
我用 QTStrToINT('33,43,32,32'),错误为:
服务器: 消息 170,级别 15,状态 1,行 1
Line 1: Incorrect syntax near '33,43,32,32'.