exec sp_name --看有几列,什么名称类型 create table tab( 就是你看到的 ) insert tab exec sp_name select * from tab drop table tab
try use UDF(can only used in sql server2000) for example: use pubs go create function fn_test(@storeid varchar(30)) returns table as begin return (select * from sales where storeid=@storeid) endgo select * form dbo.fn_test('11345')
create table tab( 就是你看到的 )
insert tab exec sp_name
select * from tab
drop table tab
for example:
use pubs
go
create function fn_test(@storeid varchar(30))
returns table
as
begin
return (select * from sales where storeid=@storeid)
endgo
select * form dbo.fn_test('11345')