输入一个表得到这个表的查询结果

没有什么技术含量,这个月没有怎么写Blog,充个数吧！

if object_id('tb') is not null drop table tb
create table tb
(
  ID int identity(1,1) primary key,
  [Name] varchar(20),
  Keyword varchar(30)
)
insert into tb select 'ws_hgo','hgo'
union all 
select 'guo','guoguo'
union all 
select 'ws','guo'

create proc proc_tb
(
  @TableName varchar(30)
)
as
declare @s varchar(100) 
select @s = isnull(@s+',','')+'['+name +']' from syscolumns where id  = object_id(@TableName) 
exec('select '+@s+' from '+@TableName) 

exec proc_tb 'tb'
ID          Name                 Keyword
----------- -------------------- ------------------------------
1           ws_hgo               hgo
2           guo                  guoguo
3           ws                   guo