`
jack1210
  • 浏览: 22731 次
  • 性别: Icon_minigender_1
  • 来自: 上海
最近访客 更多访客>>
社区版块
存档分类
最新评论
文章列表
SELECT idcard,name,CreateTime, ROW_NUMBER() OVER (PARTITION BY IDCard,DATENAME(yyyy,CreateTime) ORDER BY TID) AS OrderRank FROM Gkv_test where
SQL 多记录修改 Update Table_1 Set UserName=Table_2.UserName From Table_2,Table_1 Where Table_2.UserCode=Table_1.UserCode
1、首先用一种图片在http://www.chami.com/html-kit/services/favicon/网页中注册ico突破,然后下载下来,把图片放到工程目录下。 2、在jsp页面或html页面引入<link>标签. <link REL="SHORTCUT ICON" HREF="../images/favicon.ico"/>
//添加jQuery cookie 功能 jQuery.cookie = function(name, value, options) {     if (typeof value != 'undefined') { // name and value given, set cookie         options = options || {};         if (value === null) {             value = '';             options.expires = -1;         }         var expires = ...
//js判断Ie 版本 function IeVesion() { var Sys = {}; var ua = navigator.userAgent.toLowerCase(); var s; (s = ua.match(/msie ([\d.]+)/)) ? Sys.ie = s[1] : (s = ua.match(/firefox\/([\d.]+)/)) ? Sys.firefox = s[1] : (s = ua.match(/chrome\/([\d.]+)/)) ? Sys.chrome = s[1] : (s = ua.match(/opera.( ...
Tomcate启动内存设置 其初始空间(即-Xms)是物理内存的1/64,最大空间(-Xmx)是物理内存的1/4。可以利用JVM提供的-Xmn -Xms -Xmx等选项可 进行设置     实例,以下给出1G内存环境下java jvm 的参数设置参考: JAVA_OPTS="-server -Xms800m -Xmx800m  -XX:PermSize=64M -XX:MaxNewSize=256m -XX:MaxPermSize=128m -Djava.awt.headless=true " JAVA_OPTS="-server -Xms768m -X ...
----******把查询的结果集放到游标中,然后根据游标的状态循环读取******** CREATE PROCEDURE Syncdata_Hypertesionperson AS BEGIN SET NOCOUNT ON; declare @yks_id varchar(50) declare @jk_id varchar(50) -- ************************************修改的操作     DECLARE CUR_JK_HP CURSOR FOR select yks.shoufid from dbo.gcv_hypertensionpers ...
父页面:      $("#showmodaldialog").click(function() { var result = window.showModalDialog("<%=request.getContextPath()%>/gcbase/components/certification/showmodal.jsp?type=1","aa","dialogWidth=400px;dialogHeight=100px"); var splitRs = result.split(" ...
1.绝对值   SQL:select abs(-1) value   O:select abs(-1) value from dual   2.取整(大)   S:select ceiling(-1.001) value   O:select ceil(-1.001) value from dual   3.取整(小)   S:select floor(-1.001) value   O:select floor(-1.001) value from dual   4.取整(截取)   S:select cast(-1.002 as int) value   O:select tru ...
<input name="zip" maxlength="6" type="text" id="zip" value='' onkeypress="var k=event.keyCode; if (((k==46)||(k <=57 && k>=48)) &&(k!=102)) return true;else return false" />
1.<link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.10/themes/base/jquery-ui.css" type="text/css" media="all" />   2.<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js" type="text/j ...
一、基础 1、说明:创建数据库 CREATE DATABASE database-name 2、说明:删除数据库 drop database dbname 3、说明:备份sql server --- 创建 备份数据的 device USE master EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat' --- 开始 备份 BACKUP DATABASE pubs TO testBack 4、说明:创建新表 create table tabname(col1 type1 [not null] [p ...
CREATE PROCEDURE Proc_Syn_Data AS BEGIN     SET NOCOUNT ON;     DECLARE @ID varchar(50); DECLARE @Name varchar(100); DECLARE @keyID varchar(50); DECLARE @updatetime varchar(50); -- 1.声明游标     DECLARE CUR_MonthID CURSOR FOR SELECT SchoolID,SName FROM dbo.GK_SchoolInfo DECLARE CUR_MonthID2 CURSO ...
<script type="text/javascript" src="../jquery.js"></script> /**Jquery Cookie***/ jQuery.cookie = function(name, value, options) {     if (typeof value != 'undefined') { // name and value given, set cookie         options = options || {};         if (value === null) {   ...
Global site tag (gtag.js) - Google Analytics