摘要：
1、sql select @rownum := @rownum + 1 as 'row',a.service_goods_name,a.num from ( select t.service_goods_name,count(t.service_goods_id) as num,t.ser_addr 阅读全文
摘要：
一、基本语句，剩下的自己组合。 ALTER proc getStudentNum(@param nvarchar(50),@StuNum int output) as select @StuNum=count(*) from BASE_LOG_INFO where CREATEOPER=@param 阅读全文