gxivwshjj

摘要： Response.ContentType = "text/html; text/plain; charset=UTF-8"; 阅读全文

摘要： List _year = new List() { "一月", "二月", "三月", "四月", "五月", "六月", "七月", "八月", "九月", "十月", "十一月", "十二月" };string delim = ","; var str = _year.Ag... 阅读全文

摘要： declare @str varchar(2000) set @str='1,2,3,4,6,8,5,9,10,11,12,13,14,15,16,17,18,19,20,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,52,53,54,55,56,57,25,27,28,58' Declare @x XML sele... 阅读全文

摘要： CREATE TABLE #tmp(m_Meter_ID varchar(20),low_Voltage int,num_Attack int,num_DER int,company_id int,aid int,cid int,selfId varchar(25))INSERT ... 阅读全文

摘要： /*declare @str1 varchar(200),@str2 varchar(200)set @str1=N'江西省南昌市其它区高新区火炬大道809号' set @str2=N'江西省南昌市其它区高新区火炬大道809号'*/ALTER FUNCTION [dbo].[F_strcompare](@str1 nVARCHAR(200), @str2 nVARCHAR(200))RETURNS numeric(3,2)ASBEGINdeclare @returnvalue numeric(3,2)set @returnvalue=0i... 阅读全文

摘要： /*只能输入数字和*,不能以0开头 onkeypress='Amount_keypress(this)' */function Amount_keypress(obj) { var e = window.event || arguments.callee.caller.arguments[0]; var keyCode = e.keyCode; var reg = /^[1-9]\d{1,4}$/ if ((obj.value.length == 0) && keyCode == 42) { event.returnValue = true; ... 阅读全文

摘要： 转自 http://www.5icool.org/demo/2012/a00552/ 阅读全文

摘要： with CTEas( SELECT A.id, B.valueFROM( SELECT id, value = CONVERT(xml,'' + REPLACE([列名], ',', '') + '') FROM 表名 where limit'*' and id=3)AOUTER APPLY( SELECT value = N.v.value('.', 'varchar(100)') FROM A.[value].nodes('/root/v') N(v))B)Se 阅读全文

摘要： dgvConfig.DataSource = CreateTable(); dgvConfig.Columns["编号"].ReadOnly = true; //只读 dgvConfig.AllowUserToAddRows = false; //不允许... 阅读全文

摘要： 1 create proc GetItems 2 ( 3 @id int 4 ,@cid int 5 ,@PageIndex int = 0 6 ,@PageSize int = 20 7 ,@TotalRecords int output 8 ) 9 as10 begin11 declare @ResultTable table12 (13 RowIndex int14 ,[id] int 15 ,[title] varchar(25) not null ... 阅读全文