上一页 1 ··· 7 8 9 10 11 12 13 下一页
摘要: VS2012代码折叠插件https://visualstudiogallery.msdn.microsoft.com/bc07ec7e-abfa-425f-bb65-2411a260b926 阅读全文
posted @ 2015-05-14 15:49 chengeng 阅读(172) 评论(0) 推荐(0)
摘要: 更新表统计,提高执行计划准确性,降低逻辑读取、IO,降低CPU占用 exec sp_updatestats 新增字段,默认其他字段计算 ALTER TABLE 表名 add 字段名 as 字段名1+字段名2 SQL查看变量的数据类型 DECLARE @Sum int--SET @Sum = 0SEL 阅读全文
posted @ 2015-04-23 11:38 chengeng 阅读(448) 评论(0) 推荐(0)
摘要: SELECT TBCITY.code collate Chinese_PRC_BIN FROM TBCITYcollate Chinese_PRC_BIN,指定按某种方式排序 阅读全文
posted @ 2015-04-22 11:42 chengeng 阅读(789) 评论(0) 推荐(0)
摘要: SELECT * from TBCITY_Temp where codein ( select code from TBCITY_Temp group by code having count(code) > 1 ) and AutoId not in (select min(AutoId) f... 阅读全文
posted @ 2015-04-22 11:28 chengeng 阅读(214) 评论(0) 推荐(0)
摘要: class SocketHelper { public delegate void Uplistbox(string txt); public Uplistbox uplb; //更新listbox委托变量 protected static readonly ILog logger = LogMan... 阅读全文
posted @ 2015-04-20 16:25 chengeng 阅读(163) 评论(0) 推荐(0)
摘要: 判断客户端设备 判断客户端设备 阅读全文
posted @ 2015-04-20 14:34 chengeng 阅读(231) 评论(0) 推荐(0)
摘要: javascript打印-打印页面设置-打印预览代码 ===================================================================关于这个组件还有其他的用法,列举如下: WebBrowser.ExecWB(1,1) 打开 ... 阅读全文
posted @ 2015-04-17 16:06 chengeng 阅读(649) 评论(0) 推荐(0)
摘要: -- ============================================= -- Author: gengc -- Create date: -- Description: -- Description: -- SELECT * from dbo.F_StringToTa... 阅读全文
posted @ 2015-03-27 13:56 chengeng 阅读(776) 评论(0) 推荐(0)
摘要: using System;using System.Collections.Generic;using System.Text;using System.Runtime.InteropServices;using System.Text.RegularExpressions;using DevSDK... 阅读全文
posted @ 2014-12-19 13:38 chengeng 阅读(2175) 评论(0) 推荐(0)
摘要: -- -- Author: gengc -- Create date: <2012-12-29> -- Description: <查看表结构> -- CREATE View ViewTableasselectobj.name as 'TableName',f.value as 'TableDesc 阅读全文
posted @ 2014-12-09 15:30 chengeng 阅读(1224) 评论(0) 推荐(0)
上一页 1 ··· 7 8 9 10 11 12 13 下一页