创建有返回值与有参数的函数
求教：
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)
