Keep it up

DECLARE @DECRYPT1 INT, @DECRYPT2 INT, @RESULT INT DECLARE CUR CURSOR FOR -- CUR라는 이름의 커서 선언 SELECT 1, 1 UNION ALL SELECT 2, 0 UNION ALL SELECT 4, 0 UNION ALL SELECT 3, 1 OPEN CUR --커서 오픈 FETCH NEXT FROM CUR INTO @DECRYPT1, @DECRYPT2 --SELECT한 값을 @DECRYPT1,@DECRYPT2 변수에 넣는다. --커서를이용해 한ROW씩 읽음 WHILE @@FETCH_STATUS = 0 BEGIN BEGIN TRY SET @RESULT = @DECRYPT1 / @DECRYPT2 -- 암호화 함수 END TRY BEGIN CATC..

ALTER ASSEMBLY(Transact-SQL) -- Drop 후 Alter ALTER ASSEMBLY SqlServerProjectComLib DROP FILE 'D:\Database\DLL\SqlServerProjectComLib.dll' -- Alter ALTER ASSEMBLY SqlServerProjectComLib FROM 'D:\Database\DLL\SqlServerProjectComLib.dll'

SSMS에서 Database/Table 리스트를 가져오는 쿼리는 아래와 같습니다. 1. Database List select * from master.dbo.sysdatabases order by 1 2. Table List select * from information_schema.tables order by TABLE_NAME