Marsen marsen

## unknow protocol
<html>
<head>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script>
  $(function(){
		$('#app-opener').bind('click',
			function(){
				var timer = setTimeout(function(){
					alert('you not installed the x-myapp!!');
				},1000);

## 自動產生亂數序號
		DECLARE @start INT = 1;
		DECLARE @end INT = 50;
		WITH #KEYS AS (
			SELECT @start AS Number, REPLACE(LEFT(NEWID(), 18), '-', '') AS [KEY]
			UNION ALL
			SELECT Number + 1, REPLACE(LEFT(NEWID(), 18), '-', '') AS [KEY]
			FROM  #KEYS
			WHERE Number < @end
		)
		SELECT * FROM #KEYS OPTION (MAXRECURSION 0)

## .On vs .Live in JQuery
<html>
<head>
<script src="http://code.jquery.com/jquery-1.8.3.min.js"></script>
<script>
$(function(){
	$('#wrapper').on('click','#onlink',function(event){
		alert('on link was clicked');
	});
	$("#livelink").live('click',function(){
		alert('live link was clicked');

## random.js
//隨機GUID
function RandomGUID(){
  return 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function(c) {
				var r = Math.random()*16|0, v = c == 'x' ? r : (r&0x3|0x8);
				return v.toString(16);
			});
}

//隨機整數
function RandomNum(Min,Max){

## templateReplace.js
    ////example
    ////http://goo.gl/FOMIgW
    //template = '<li{is Selected}>{isChecked}<a href="/learn/{rootId}/topic/{courseId}">{indexStr} {courseName}</a></li>';
    //var data = {
    //    isSelected: node.CourseId == Info.PageData.cId * 1 ? ' class="sel"' : "",
    //    isChecked: renderCheckedBox(node.CourseNodeType, node.Percentage, node.CourseId),
    //    indexStr: node.LevelIndex.join("-"),
    //    courseName: node.Name,
    //    rootId: Info.PageData.rId,
    //    courseId: node.CourseId

## parseURL.js
// This function creates a new anchor element and uses location
// properties (inherent) to get the desired URL data. Some String
// operations are used (to normalize results across browsers).

function parseURL(url) {
    var a =  document.createElement('a');
    a.href = url;
    return {
        source: url,
        protocol: a.protocol.replace(':',''),

## SQL Calendar
   DECLARE @Date DATETIME
Set @Date = GetDate()
DECLARE @Start DATETIME,@End DATETIME
   DECLARE @Index INT
   SET @Start = DATEADD(MONTH,DATEDIFF(MONTH,0,@Date),0)
   SET @End = DATEADD(MONTH,1,@Start)
   SET @Index = DATEDIFF(DAY,-1,@Start)%7 - 1;
   SET @Start = DATEADD(mm,DATEDIFF(mm,0,@Date),0)
   SET    @End = DATEADD(mm,1,@Start) - 1
   SET    @Index= DATEDIFF(day,0,@Start)%7

## NamespacePattern.js
//namespace pattern
var MYAPP = MYAPP || {};
MYAPP.namespace = function(ns_string){
  var parts = ns_string.split('.'),
      parent = MYAPP,
      i;
  if(parts[0]==="MYAPP"){
    parts = parts.slice(1);
  }


## Sql_Slipt.sql
CREATE FUNCTION [dbo].[UF_SliptToTable]
(
 @psCSString VARCHAR(8000)
)
RETURNS @otTemp TABLE(sID VARCHAR(100))
AS
BEGIN
 DECLARE @sTemp VARCHAR(100)

 WHILE LEN(@psCSString) > 0

## stopEventBubble.js
    function stopEventBubble(e) {
        if (e && e.stopPropagation) {
            e.stopPropagation();
        }
        else {//why always IE
            window.event.cancelBubble = true;
        }
    }
	<html>
	<head>
	<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
	<script>
	$(function(){
	$('#app-opener').bind('click',
	function(){
	var timer = setTimeout(function(){
	alert('you not installed the x-myapp!!');
	},1000);
	DECLARE @start INT = 1;
	DECLARE @end INT = 50;
	WITH #KEYS AS (
	SELECT @start AS Number, REPLACE(LEFT(NEWID(), 18), '-', '') AS [KEY]
	UNION ALL
	SELECT Number + 1, REPLACE(LEFT(NEWID(), 18), '-', '') AS [KEY]
	FROM #KEYS
	WHERE Number < @end
	)
	SELECT * FROM #KEYS OPTION (MAXRECURSION 0)
	<html>
	<head>
	<script src="http://code.jquery.com/jquery-1.8.3.min.js"></script>
	<script>
	$(function(){
	$('#wrapper').on('click','#onlink',function(event){
	alert('on link was clicked');
	});
	$("#livelink").live('click',function(){
	alert('live link was clicked');
	//隨機GUID
	function RandomGUID(){
	return 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function(c) {
	var r = Math.random()*16\|0, v = c == 'x' ? r : (r&0x3\|0x8);
	return v.toString(16);
	});
	}

	//隨機整數
	function RandomNum(Min,Max){
	////example
	////http://goo.gl/FOMIgW
	//template = '<li{is Selected}>{isChecked}<a href="/learn/{rootId}/topic/{courseId}">{indexStr} {courseName}</a></li>';
	//var data = {
	// isSelected: node.CourseId == Info.PageData.cId * 1 ? ' class="sel"' : "",
	// isChecked: renderCheckedBox(node.CourseNodeType, node.Percentage, node.CourseId),
	// indexStr: node.LevelIndex.join("-"),
	// courseName: node.Name,
	// rootId: Info.PageData.rId,
	// courseId: node.CourseId
	// This function creates a new anchor element and uses location
	// properties (inherent) to get the desired URL data. Some String
	// operations are used (to normalize results across browsers).

	function parseURL(url) {
	var a = document.createElement('a');
	a.href = url;
	return {
	source: url,
	protocol: a.protocol.replace(':',''),
	DECLARE @Date DATETIME
	Set @Date = GetDate()
	DECLARE @Start DATETIME,@End DATETIME
	DECLARE @Index INT
	SET @Start = DATEADD(MONTH,DATEDIFF(MONTH,0,@Date),0)
	SET @End = DATEADD(MONTH,1,@Start)
	SET @Index = DATEDIFF(DAY,-1,@Start)%7 - 1;
	SET @Start = DATEADD(mm,DATEDIFF(mm,0,@Date),0)
	SET @End = DATEADD(mm,1,@Start) - 1
	SET @Index= DATEDIFF(day,0,@Start)%7
	//namespace pattern
	var MYAPP = MYAPP \|\| {};
	MYAPP.namespace = function(ns_string){
	var parts = ns_string.split('.'),
	parent = MYAPP,
	i;
	if(parts[0]==="MYAPP"){
	parts = parts.slice(1);
	}
	CREATE FUNCTION [dbo].[UF_SliptToTable]
	(
	@psCSString VARCHAR(8000)
	)
	RETURNS @otTemp TABLE(sID VARCHAR(100))
	AS
	BEGIN
	DECLARE @sTemp VARCHAR(100)

	WHILE LEN(@psCSString) > 0
	function stopEventBubble(e) {
	if (e && e.stopPropagation) {
	e.stopPropagation();
	}
	else {//why always IE
	window.event.cancelBubble = true;
	}
	}