[jami] - for the better

truncate 권한만 부여하기?? http://blog.sqlauthority.com/2010/12/20/sql-server-securing-truncate-permissions-in-sql-server/http://www.mssqltips.com/sqlservertip/2583/grant-truncate-table-permissions-in-sql-server-without-alter-table/

계층구조 쿼리에 사용.참조 : http://msdn.microsoft.com/en-us/library/ms186243%28v=sql.105%29.aspx sampleWITH CTE_AE_CODE_H AS ( SELECT * , 0 AS LEVEL , CAST(RANK AS DECIMAL(20)) AS SORT --소팅(문자열로 변환 후 소팅해야 함) , CAST(CODE_NAME AS VARCHAR(1000)) AS CODE_PATH FROM IAMS.DBO.AE_CODE_H WHERE 1 = 1 AND UP_CODE_ID = '*' --AND UP_CODE_ID = 'ROOT_ASSET_TYPE' UNION ALL SELECT A.* , R.LEVEL + 1 AS LEVEL , CAST(R.SORT *..