表变量: declare @aa table (a char(10),b char(50))eg:
create function test (@djbh char(10))
returns @aa table (a char(10),b char(50))
as
begin
insert into @aa
select '1','2' return
end
create function test (@djbh char(10))
returns @aa table (a char(10),b char(50))
as
begin
insert into @aa
select '1','2' return
end
insert @a values(1,'sdf')select * from @a
create table 表名(字段1 类型,字段2 类型,字段3 类型)