[MS-SQL 2008] 향상된 T-SQL문

1. 변수선언시 초기화 가능

    DECLARE @praNum int = 100
    SELECT @praNum
    GO

2. 향상된 Insert 문

    INSERT INTO #Temp VALUES(1, '김'), (2, '이'), (3, '박')
    GO

3. GROUPING SET

    SELECT ID, MON, COUNT(QTY) AS CNT
    FROM Customer
    GROUP BY GROUPING SETS ((ID), (MON))
    GO

4. MERGE

   MERGE TableA AS A
   USING (SELECT col1, col2 FROM TableB) AS B (col1, col2)
   ON (A.col1 = B.col1)
   WHEN MATCHED THEN
     UPDATE SET A.col2 = B.col2
   WHEN NOT MATCHED THEN
     INSERT(col1, col2) VALUES(B.col1, B.col2);
   GO