创建有返回值与有参数的函数
求教：
CREATE FUNCTION my_function(@user_Name varchar(128),@password int(6))

returns varchar(255)--设置返回值，记住是returns 而不是return

AS

BEGIN

DECLARE @result varchar(5)

DECLARE @fagle varchar(5)

SET @result = select users.user_Name from USERS as users where users.user_Name = @user_Name and users.password = @password

IF @result = ''

BEGIN

SET @fagle = 'NO'

END

ELSE

BEGIN

SET @falge = 'YES'

END

return @result --返回结果

END

select附近有错误，求大侠讲解


原文 http://blog.csdn.net/zhdd1234/article/details/4734789


[解决办法]
select @result=users.user_Name from USERS as users where users.user_Name = @user_Name and users.password = @password
[解决办法]
SET @result = (select users.user_Name from USERS as users where users.user_Name = @user_Name and users.password = @password)