摘要：Table1表结构如下idgroup1group2money2232 gp1aaa234.32233 gp2bbb90.32234 gp1aaa804.392235 gp2bbb02236 gp2bbb882237 gp1aaa72238 gp1aaa234.3 2239 gp2bbb88 需要获得如下查询结果:idgroup1group2money num2234 gp1aaa804.39 12232 gp1aaa234.3 22238 gp1aaa234.3 22237 gp1aaa732233 gp2bbb90.3 12236 gp2bbb88 22239 gp2bbb8822235 g 阅读全文

摘要：---表名比对SELECT t.name,s.name FROM leatest.dbo.sysobjects t full join les_server.dbo.sysobjects s on t.name=s.nameWHERE t.xtype='U' and t.category =0--and s.xtype='U' and s.category =0order by t.name --列比较select aa.*,bb.* from (select ss.name,sj.name as TableName from leatest.dbo.sysco 阅读全文

摘要：select ROW_NUMBER() OVER (order by Id DESC) as aa 阅读全文

摘要：#region Method for InsertSqLBuilder //构建InsertSqLBuilder /// <summary> /// 构建InsertSqLBuilder /// </summary> /// <param name="dataTable">数据表</param> /// <param name="dataConnParm">数据连接参数</param> /// <returns></returns> public string 阅读全文

摘要：使用时，首次调用，将@docount设为1，获得满足条件的记录行数 以后调用时，将@docount设为0，获得指定页的记录 CREATE procedure pageer_rnewlist (@pagesize int, @pageindex int, @docount bit, @education varchar(50) ) as set nocount on if(@d... 阅读全文