create function xx()
returns varchar(8000)
as
begin
declare @sql int;
set @sql=1;
return @sql
end
GO
select dbo.xx()
GO
create function xx1()
returns table
as
return
(
select * from tb
)
GO
select * from dbo.xx1()
GO
create function xx2()
returns @x table (sql1 int)
as
begin
insert into @x select id from tb
return
end
GO
select * from dbo.xx2()
内置函数的三个不同类型的创建方式
最新推荐文章于 2022-07-26 16:32:02 发布