老牛脱机

摘要： Create proc [dbo].[GetHospitalList] @pagesize int, @page int, @hospitalcode nvarchar(50), @citycode nvarchar(50), @type nvarchar(50), @memo nvarchar(50), @provincecode nvarchar(50), @status nvarchar... 阅读全文

摘要： ALTER proc [dbo].[PIVOT_Test] @year1 varchar(4), @year2 varchar(4), @year3 varchar(4), @quarter varchar(2) as select column1,sum(column2) column2,year,month into #t1 from table1 where year in(@year1... 阅读全文