[MS-SQL] tips

# collate 변경

-- SINGLE USER MODE 변경

ALTER DATABASE MyTestDB

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE;

 

-- 작업 진행

ALTER DATABASE

MyOptionsTest

COLLATE

korean_wansung_ci_as;

 

ALTER TABLE

MyTestTable

ALTER COLUMN

MyColumnName varchar(50)

COLLATE

korean_wansung_ci_as;

 

-- MULTI USER MODE 복귀 (기본값)

ALTER DATABASE MyTestDB

SET MULTI_USER ;