jquery 过滤 ajax 返回HTML值
Code
$.get("/product/favproduct.asp",function(data){
var stext = $(data).find('div#listBuy').html();
$(".list").html(stext)
})
key:jquery ajax 返回值 过滤
Javascript 正则表达式中的后向引用
Code
$(".nextPage a").live("click",function(){
var url= $(".Switch ul li[class='current'] a").attr("href");
var href = $(this).attr("href")
var pattern = /pagecurrent=(\d)/ig
if(pattern.test(href))
{
var intpagesize = RegExp.$1;//表示与模式中第一个括号匹配的内容
url += "?pagecurrent="+intpagesize
}
InvokeAjax(url)
return false
});
key:javascript 正则 引用
Jquery find 和filter 的区别
Code
<div class="css">
<p class="rain">测试1</p>
</div>
<div class="rain">
<p>测试2</p>
</div>
测试
var $find = $("div").find(".rain");
alert( $find.html() ) ;
输出：？
var $filter = $("div").filter(".rain");
alert( $filter.html() );
输出：？
find()会在div元素内 寻找 class为rain 的元素。
而filter()则是筛选div的class为rain的元素。
一个是对它的子集操作，一个是对自身集合元素筛选。
另外find()其实还可以用选择器表示:
var $select = $("div .rain");
原文链接：http://www.cssrain.cn/article.asp?id=1086
CSS 永远置底
http://www.cssstickyfooter.com/cn/using-sticky-footer-code.html
Jquery 模仿用户操作？
$("#Exhibit").click();//触发ID为Exhibit的元素的单击事件
//或
$("#Exhibit").trigger(“click”);
//当一个操作会触发1个以上事件时先绑定的先执行
更新存储过程使用VSS
FTP CMD 命令
Jquery fn.Load 方法 加载指定块中的HTML
$("#divLoginfloat").load("/user/floatLogin.asp .floatingContent",function(){})
//把 user/floatLogin.asp中class =” floatingContent” 的容器里的内容加载到id=” divLoginfloat”的容器里+
T-SQL 增加字段
ALTER TABLE table_name ADD column_name data_type
alter table 表 add 字段名 类型 约束
http://topic.csdn.net/t/20050511/14/3998169.html
key :增加字段 SQL
T-SQL: Null <> 1 ?
SET @isAdmin = ISNULL(@isAdmin,0)
IF(@isAdmin <> 1) --Null <> 1永远是ELSE
域名解析
www.mydomain.com
主机名： www
域名：mydomain.com
比较 SELECT INTO 和 INSERT INTO SELECT 两种表复制语句
http://www.cnblogs.com/freshman0216/archive/2008/08/15/1268316.html
应用：
Code
--1 正确的方法
SELECT * INTO #LW FROM tbl_company_LW WHERE 1=0
IF @isAdmin <> 1
INSERT INTO #LW SELECT * FROM tbl_company_LW WHERE companyID = @companyid AND adminStatus = 0
ELSE
INSERT INTO #LW SELECT * FROM tbl_company_LW WHERE companyID = @companyid
--2 错误的提示#LW已存在
IF @isAdmin <> 1
SELECT * INTO #LW FROM tbl_company_LW WHERE companyID = @companyid AND adminStatus = 0
ELSE
SELECT * INTO #LW FROM tbl_company_LW WHERE companyID = @companyid
仅复制表结构
select * into B
from A
truncate table B
这样就将整个表A的结构复制给了表B ,但不包含表A的类容
应用：
SELECT userid,webName,isNew INTO #LW FROM tbl_company_LW TRUNCATE TABLE #LW
http://topic.csdn.net/t/20061014/14/5082022.html
字符串转JSON
http://www.cnitblog.com/yemoo/archive/2007/10/08/34526.html
KEY: 字符串 json
SQL的datetime类型数据转换为字符串格式大全
http://www.cnblogs.com/ajunsoft/archive/2009/05/05/1449693.html
Code
SELECT CONVERT(varchar,getdate())
,CONVERT(varchar,getdate(),0) as '0'
,CONVERT(varchar,getdate(),1) as '1'
,CONVERT(varchar,getdate(),2) as '2'
,CONVERT(varchar,getdate(),3) as '3'
,CONVERT(varchar,getdate(),4) as '4'
,CONVERT(varchar,getdate(),5) as '5'
,CONVERT(varchar,getdate(),6) as '6'
,CONVERT(varchar,getdate(),7) as '7'
,CONVERT(varchar,getdate(),8) as '8'
,CONVERT(varchar,getdate(),9) as '9'
,CONVERT(varchar,getdate(),10) as '10'
,CONVERT(varchar,getdate(),11) as '11'
,CONVERT(varchar,getdate(),12) as '12'
,CONVERT(varchar,getdate(),13) as '13'
,CONVERT(varchar,getdate(),14) as '14'
,CONVERT(varchar,getdate(),100) as '100'
,CONVERT(varchar,getdate(),101) as '101'
,CONVERT(varchar,getdate(),102) as '102'
,CONVERT(varchar,getdate(),103) as '103'
,CONVERT(varchar,getdate(),104) as '104'
,CONVERT(varchar,getdate(),105) as '105'
,CONVERT(varchar,getdate(),106) as '106'
,CONVERT(varchar,getdate(),107) as '107'
,CONVERT(varchar,getdate(),108) as '108'
,CONVERT(varchar,getdate(),109) as '109'
,CONVERT(varchar,getdate(),110) as '110'
,CONVERT(varchar,getdate(),111) as '111'
,CONVERT(varchar,getdate(),112) as '112'
,CONVERT(varchar,getdate(),113) as '113'
,CONVERT(varchar,getdate(),114) as '114'
CASE (Transact-SQL)
http://msdn.microsoft.com/zh-cn/library/ms181765.aspx
Simple CASE expression:
CASE input_expression
WHEN when_expression THEN result_expression [ ...n ]
[ ELSE else_result_expression ]
END
Searched CASE expression:
CASE
WHEN Boolean_expression THEN result_expression [ ...n ]
[ ELSE else_result_expression ]
END
应用:
1
SET @strWhere = @strWhere +
CASE
WHEN 'TBL_PRODUCT' THEN ' and (T.loc_name LIKE ''%'+@keyword+'%'' OR T.en_name LIKE ''%'+@keyword+'%'' OR T.loc_keyword like ''%'+@keyword+'%'' or T.en_keyword like ''%'+@keyword+'%'') '
WHEN 'TBL_BUYINGOFFER' THEN ' and (T.loc_title LIKE ''%'+@keyword+'%'' OR T.en_title LIKE ''%'+@keyword+'%'' OR T.loc_keyword like ''%'+@keyword+'%'' or T.en_keyword like ''%'+@keyword+'%'') '
WHEN 'TBL_SELLINGOFFER' THEN ' and (T.loc_title LIKE ''%'+@keyword+'%'' OR T.en_title LIKE ''%'+@keyword+'%'' OR T.loc_keyword like ''%'+@keyword+'%'' or T.en_keyword like ''%'+@keyword+'%'') '
WHEN 'TBL_BID' THEN ' AND (T.title LIKE ''%'+@keyword+'%'' OR T.keyword LIKE ''%'+@keyword+'%'') '
ELSE ''
END
2
DECLARE @STR NVARCHAR(100)
DECLARE @INT NVARCHAR(100)
SET @INT = '1'
SET @STR =
CASE
WHEN @INT = '2' OR @INT= '3' THEN 'OK'
WHEN @INT = '1' THEN 'D'
ELSE 'NO'
END
PRINT @STR
SQL: 判断字段中的中文
http://topic.csdn.net/t/20050722/10/4160858.html