- 传表名进去就行了(procName @Table = 'master')
- CREATE proc procName
- @Table varchar(50)
- as
- declare @SqlString varchar(2000)
- set @SqlString = 'select * form ' + @Table
- exec (@SqlString)
- 还可以传不同的表,不同的字段(procName @Field = '字段名1,字段名2,字段名3', @Table = 'master')
- CREATE proc 存储过程名称
- @Field varchar(50),
- @Table varchar(50)
- as
- declare @SqlString varchar(2000)
- set @SqlString = 'select ' + @Field + 'form ' + @Table
- exec (@SqlString)
来源: http://www.phpxs.com/code/1008623/