***向专家求教自定义函数的问题
Chiun 2005-06-07 12:43:27 我自定义了一个函数
CREATE FUNCTION IFKRaiseError
-- Raise user defined message
(@ErrorCode INT )
RETURNS NVARCHAR(256) -- Error message
AS
BEGIN
DECLARE @MsgLangID INT
DECLARE @ErrorMessage NVARCHAR(256)
SELECT @MsgLangID = msglangid FROM master..syslanguages WHERE name = @@LANGUAGE
SELECT @ErrorMessage = description FROM master..sysmessages WHERE error = @ErrorCode AND msglangid = @MsgLangID
IF(@ErrorMessage IS NULL AND @MsgLangID <> 1033)
SELECT @ErrorMessage = description FROM master..sysmessages WHERE msglangid = 1033 -- if failed use default language us_english
RETURN @ErrorMessage
END
我希望能测试该函数的返回值
于是我用以下代码希望能打印出我运行结果
declare @a nvarchar(256)
set @a = IFKRaiseError(1)
print @a
但是编译错误:
Server: Msg 195, Level 15, State 10, Line 3
'IFKRaiseError' is not a recognized function name.
请问是为什么,该如何调用?
另外自定义函数里为什么不允许使用print?