짬타이거 화이팅!

dbcc sqlperf(logspace)

BACKUP LOG database_dbf TO DISK='NUL'

DBCC SHRINKDATABASE (database_dbf)

/*

SELECT * FROM [dbo].[FN_SPLIT] ('감기,콧물,어지러움,콧물기침,열,가래,몸살',',')

*/

CREATE FUNCTION [dbo].[FN_SPLIT]

(

    @PARAM VARCHAR(MAX) -- 대상문자열

    , @DIV VARCHAR(1) -- 특정구분자

)

RETURNS

@RESULT TABLE

(

    [VALUE] VARCHAR(MAX)

    , [ORDER] INT

)

AS

BEGIN

    DECLARE @INDEX INT

    DECLARE @POS INT

    DECLARE @ORDER INT

    DECLARE @TEMP VARCHAR(MAX)

    SET @INDEX = 1

    SET @POS = 1

    SET @ORDER = 1

    WHILE @POS > 0

    BEGIN

        SET @POS = CHARINDEX(@DIV, @PARAM, @INDEX)

        IF @POS = 0

        BEGIN

            SET @TEMP = RIGHT(@PARAM, LEN(@PARAM) - @INDEX + 1)

        END

        ELSE

        BEGIN

            SET @TEMP = SUBSTRING(@PARAM, @INDEX, @POS - @INDEX)

        END

        IF LEN(@TEMP) > 0

        BEGIN

            SET @TEMP = RTRIM(LTRIM(@TEMP))

            INSERT INTO @RESULT VALUES (@TEMP, @ORDER)

        END

       SET @INDEX = @POS + 1

       SET @ORDER = @ORDER + 1

    END

RETURN

END

--실행결과--

SELECT * FROM [dbo].[FN_SPLIT] ('감기,콧물,어지러움,콧물기침,열,가래,몸살',',')

-- 중복 데이터 확인
      SELECT  Title, COUNT(*) AS CNT
         FROM  TableName
  GROUP BY  Title
      HAVING  COUNT(*) > 1

-- 결과
Title   CNT
----   ---
1        5
2        4
3        2.

(3개 행 적용됨)

-- 실행
SELECT  COUNT(*)
   FROM  TableName
-- DELETE TableName
 WHERE  Seq NOT IN (SELECT  MAX(Seq)
                                    FROM  TableName
                             GROUP BY  Title)

Password:
	Weak Medium Strong

$.fn.passwordStrength = function( options ){
	return this.each(function(){
		var that = this;that.opts = {};
		that.opts = $.extend({}, $.fn.passwordStrength.defaults, options);

		that.div = $(that.opts.targetDiv);
		that.defaultClass = that.div.attr('class');

		that.percents = (that.opts.classes.length) ? 100 / that.opts.classes.length : 100;

		v = $(this)
		.keyup(function(){
			if( typeof el == "undefined" )
			this.el = $(this);
			var s = getPasswordStrength (this.value);
			var p = this.percents;
			var t = Math.floor( s / p );

			if( 100 <= s )
			t = this.opts.classes.length - 1;

			this.div
			.removeAttr('class')
			.addClass( this.defaultClass )
			.addClass( this.opts.classes[ t ] );
		})
		# Removed generate password button creation
	});

	function getPasswordStrength(H){
		var D=(H.length);

		# Added below to make all passwords less than 4 characters show as weak
		if (D<4) { D=0 }


		if(D>5){
			D=5
		}
		var F=H.replace(/[0-9]/g,"");
		var G=(H.length-F.length);
		if(G>3){G=3}
		var A=H.replace(/\W/g,"");
		var C=(H.length-A.length);
		if(C>3){C=3}
		var B=H.replace(/[A-Z]/g,"");
		var I=(H.length-B.length);
		if(I>3){I=3}
		var E=((D*10)-20)+(G*10)+(C*15)+(I*10);
		if(E<0){E=0}
		if(E>100){E=100}
		return E
	}

	# Removed generate password function
};

$(document)
.ready(function(){
	$('input[name="password2"]').passwordStrength({targetDiv: '#iSM',classes : Array('weak','medium','strong')});

});

소스코드

<div id="fb-root"></div>

<script>(function(d, s, id) {

  var js, fjs = d.getElementsByTagName(s)[0];

  if (d.getElementById(id)) {return;}

  js = d.createElement(s); js.id = id;

  js.src = "//connect.facebook.net/ko_KR/all.js#xfbml=1";

  fjs.parentNode.insertBefore(js, fjs);

}(document, 'script', 'facebook-jssdk'));</script>

<div class="fb-like" data-href="좋아요컨텐츠 링크등록" data-send="false" data-layout="button_count" data-width="450" data-show-faces="true" data-font="arial"></div>

기타 설정
  페이스북에서 보여지는 좋아요 타이틀
  <meta name="title" contelt="좋아요 타이틀" />

  페이스북에서 보여지는 좋아요 요약글
  <meta name="description" content="요약글 솰라솰라~" />

  페이스북에서 보여지는 좋아요 대표이미지
  <like rel="image_src" href="이미지경로" />