CREATE FUNCTION fnGetLevelbySum(@summary bigint)
RETURNS NVARCHAR(50)
AS
BEGIN
IF @summary>=320
RETURN '优'
IF @summary<=320 AND @summary>=280
RETURN '中'
IF @summary<=280 AND @summary>=100
RETURN '及格'
IF @summary<=100
RETURN '不及格'
END
GO提示需要返回值 问题是我给了返回值啊
RETURNS NVARCHAR(50)
AS
BEGIN
IF @summary>=320
RETURN '优'
IF @summary<=320 AND @summary>=280
RETURN '中'
IF @summary<=280 AND @summary>=100
RETURN '及格'
IF @summary<=100
RETURN '不及格'
END
GO提示需要返回值 问题是我给了返回值啊
RETURNS NVARCHAR(50)
AS
begin
declare @r NVARCHAR(50)
IF @summary>=320
set @r=N'优'
IF @summary<=320 AND @summary>=280
set @r=N'中'
IF @summary<=280 AND @summary>=100
set @r=N'及格'
IF @summary<=100
set @r=N'不及格'
return @r
end
GO