摘要：
1.MSSQLSERVER的协议：VIA禁用，其余三个协议启用2.客户端协议：VIA禁用，其余三个协议打开3.下面是关于数据库实现的：将一个表中的数据插入到另一个表中的存储过程CREATE PROCEDURE [dbo].[proc_Statics_UserRecordMonth](@year int,@month int,@CityId int)ASBEGIN SET NOCOUNT ON; insert into 表1(ProcessedInput, InputSpelling ,CityId, CityName, [Year], [Month], ProcessedInputCl... 阅读全文
摘要：
1.存储过程：CREATE PROCEDURE hlsj (@month int, @year int, @CityId int)ASBEGIN SET NOCOUNT ON;select top 100 count(ProcessedInput) as sl,ProcessedInput from 表名 where [month]=@month and [year]=@year and CityId=@CityId group by ProcessedInput order by sl descENDGO2.数据绑定，显示： SqlParameter[] para = new Sql... 阅读全文