34,838
社区成员




if object_id('f_rttable','fn') is not null
drop function f_rttable
go
create function f_rttable(@tname nvarchar(10))
returns table
as
return (select * from @tname)
--存储过程
if object_id('f_rttable','P') is not null drop proc f_rttable
go
create proc f_rttable
@tname nvarchar(10)
as
exec('select * from '+@tname)
go
exec f_rttable 'tb'
/*ID Item User
----------- ---------- ----------
1 B wang
1 C wang
2 B fang
2 D wang
3 B wang
4 D fang*/