创建有返回值与有参数的函数

[cjlearncsharp]

求教：
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

[dawugui]

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

[cjlearncsharp]

谢谢！！

[开着拖拉机泡妞]

[Quote=引用 3 楼 cjlearncsharp 的回复:]

谢谢！！
[/Quote]

势利眼，恶心，妈的难道我的就不是那个意思？蛋疼

[cjlearncsharp]

[Quote=引用 4 楼 travylee 的回复:]

引用 3 楼 cjlearncsharp 的回复:

谢谢！！


势利眼，恶心，妈的难道我的就不是那个意思？蛋疼
[/Quote]
不好意思，因为我是菜鸟，3楼给代码加了括号，运行成功了，我以为你只是告诉我哪里错了