游标错误
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 参数 在哪里用到的