CREATEFUNCTION om_get_partcity_f(
@is_area_id
varchar(32)
--区域编码
)
AS
return varchar
declare
@vs_return_partcity
varchar(8),
--分区地市
@vn_area_level
numeric(2,0)
BEGIN
SELECT@vn_area_level=f_area_level
FROM om_area_t
WHERE f_area_id = @is_area_id
IF @@rowcount=0
BEGIN
select @vs_return_partcity = '999'
RETURN @vs_return_partcity
END
IF @vn_area_level < 3 BEGIN
select @vs_return_partcity = @is_area_id
END
ELSE
BEGIN
select @vs_return_partcity = substring(@is_area_id,4,3)
END
RETURN @vs_return_partcity
END
编译后：
Incorrect syntax near the keyword 'AS'.
Server Message:Number178, Severity15
Server 'MBSS', Line 5:
A RETURN statement with a return status may only be used in a SQL stored procedure.
Server Message:Number178, Severity15
Server 'MBSS', Line 18:
A RETURN statement with a return status may only be used in a SQL stored procedure.
Server Message:Number178, Severity15
Server 'MBSS', Line 29:
A RETURN statement with a return status may only be used in a SQL stored procedure.
|
