
Code
--Developer:zhihui zhou
--Date:GETDATE() as 2008-10-18
--Email:zhou5791759@163.com
--QQ:297510342
create function fct_test(@MyChose nvarchar(50))
returns nvarchar(50)
as
begin
declare @strReturn nvarchar(50)
if(@MyChose = 'OK')
set @strReturn = '选择' + @MyChose
else
set @strReturn = '选择其它'
return @strReturn
end
go
----------------------------------------
Call:
select dbo.fct_test('OK')
----------------------------------------
Back:
'选择OK'
posted @
2008-10-19 01:29
挟风凌月
阅读(
1927)
评论()
编辑
收藏
举报