文章列表
MySQl时间自定义排序
- 博客分类:
- MSQL
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) {
...