본문 바로가기

IT/DB

DB 관련 공부

  • SET NOCOUNT ON
    http://egloos.zum.com/hsouhy/v/399641

  • SET LOCK_TIMEOUT
    https://msdn.microsoft.com/ko-kr/library/ms189470(v=SQL.120).aspx

  • SET XACT_ABORT ON
    http://fbshot.blog.me/80162695844

  • SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
    http://eastluck.tistory.com/1

  • 테이블 구조 확인
    • 테이블 명에다가 ALT + F1
    • sp_help 테이블명