游标错误
create FUNCTION [dbo].[gettypeName](@userNames nvarchar(1000))
RETURNS nvarchar(1000)
AS
BEGIN
DECLARE @RET nvarchar(1000)
DECLARE @struid nvarchar(100)
declare @vname nvarchar(100)
DECLARE table_cur CURSOR FOR
select short_str from jobs
OPEN table_cur
FETCH NEXT FROM table_cur INTO @vname
WHILE @@fetch_status = 0
BEGIN
if exists(select uid FROM [dbo].[user] where uname=@vname)
begin
select @struid=uid FROM [dbo].[user] where uname=@vname
set @RET=@RET+@struid
end
FETCH NEXT FROM table_cur INTO @vname;
END
CLOSE table_cur;
DEALLOCATE table_cur;
RETURN(@RET)
END;
哪错了呢
[解决办法]
你这个函数是干什么用的 @userNames 参数 在哪里用到的
