CREATE FUNCTION dbo.getindustry
(
@id int
)
RETURNS varchar
AS
BEGIN
declare @industry varchar(50)
set @industry=''
if @id=13
set @industry='房产'
if @id=1
set @industry='医药'
if @id=3
set @industry='IT'RETURN @industry
END
print dbo.getindustry(13)就是没有返回值。哪出错了嘛
sql 2000
(
@id int
)
RETURNS varchar
AS
BEGIN
declare @industry varchar(50)
set @industry=''
if @id=13
set @industry='房产'
if @id=1
set @industry='医药'
if @id=3
set @industry='IT'RETURN @industry
END
print dbo.getindustry(13)就是没有返回值。哪出错了嘛
sql 2000
create FUNCTION dbo.getindustry
(
@id int
)
RETURNS varchar(30)
AS
BEGIN
declare @industry varchar(50)
set @industry=''
if @id=13
set @industry='房产'
if @id=1
set @industry='医药'
if @id=3
set @industry='IT' RETURN @industry
END
drop function dbo.getindustry
go
CREATE FUNCTION dbo.getindustry
(
@id int
)
RETURNS varchar(50)
AS
BEGIN
declare @industry varchar(50)
--set @industry=''
if @id=13
set @industry='房产'
if @id=1
set @industry='医药'
if @id=3
set @industry='IT' RETURN @industry
END
go
select dbo.getindustry(13)