본문 바로가기

DataBase/MSSQL

 (14)
[MSSQL2005]암복호화 -- [ 마스터키 생성 ] CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Password' -- [ 인증서 생성 ] CREATE CERTIFICATE CERT_FES_01 WITH SUBJECT = 'Password' -- [ 대칭키 생성 ] CREATE SYMMETRIC KEY FES_KEY_01 WITH KEY_SOURCE = 'Password', ALGORITHM = RC4_128 , IDENTITY_VALUE = 'Password' ENCRYPTION BY CERTIFICATE CERT_FES_01 --작업 추가 OPEN SYMMETRIC KEY FES_KEY_01 DECRYPTION BY CERTIFICATE CERT_FES_01; INSERT INTO TMP_E..
[MSSQL2000]한글검색쿼리 select DATALENGTH(member_pwd), len(member_pwd), member_pwd from tbl_member where LEN(member_pwd)DATALENGTH(member_pwd) 컬럼 between 'ㄱ' and '힣'
[MSSQL]LDF용량축소 exec sp_helpdb [DB명] use master backup log [DB명] with truncate_only use [DB명] dbcc shrinkfile ([DB명]_Log, 10)
[MSSQL2000]PK확인 DECLARE @TABLE_NAME AS VARCHAR(30) SET @TABLE_NAME = 'tbl_research_admin' SELECT [컬럼명] = D.COLUMN_DESC , [컬럼ID] = C.COLUMN_NAME , [Type & Length] = COLUMN_TYPE , [NOT NULL] = CASE WHEN C.IS_NULLABLE = 'NO' THEN 'Y' ELSE '' END , PK = ISNULL(K.PK, '') , FK = ISNULL(K.FK, '') , INX = ISNULL(K.INX, '') FROM ( SELECT TABLE_NAME , COLUMN_NAME , IS_NULLABLE , COLUMN_TYPE = CASE WHEN DATA_TYPE IN ('VAR..
[MSSQL]MDF LDF이전방법 --sp_detach_db 'sudukwon_new' 파일 이동 --sp_attach_db 'sudukwon_new','D:\BackUp\MSSQL\DATA\sudukwon_new.mdf','D:\BackUp\MSSQL\DATA\sudukwon_new_log.ldf'
[DB]자주 쓰는 명령어 자동증가 초기화 : DBCC CHECKIDENT (테이블명, RESEED,0 )

티스토리툴바