对比SQL参数数量

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

/*查询执行SQL升级前后，存储过程的参数数量变化*/ --升级前 select a.id,b.name, count(1) as c_count　　 into TT99812 from syscolumns a join (select id,name from sysobjects where OBJECTPROPERTY(id, N'IsProcedure') =1) b on a.id=b.id group by a.id,b.name    -- 升级后   select a.id,b.name, count(1) as c_count into TT99813 from syscolumns a join (select id,name from sysobjects where OBJECTPROPERTY(id, N'IsProcedure') =1) b on a.id=b.id group by a.id,b.name   -- 对比   select * from TT99812 a join TT99813 b on a.name=b.name where a.c_count<>b.c_count       drop table TT99812   drop table TT99813