清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | 传表名进去就行了(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) |