#title 계산된 컬럼 만들기
[[TableOfContents]]

{{{
create table t (c1 varchar(50))
select * from t where lower(c1) = '00'

create table t (c1 varchar(50), c2 as lower(c1))
create table t (c1 varchar(50), c2 as lower(c1), c3 as lower(c1) persisted)
}}}

{{{
alter table #temp3
add avt_ctgr_lv5 as 
	case 
		when src_avt_key in(3,6,8) then '아바타'
		else '기타' end
go

alter table #temp3
drop column avt_ctgr_lv5

alter table #temp3
add avt_ctgr_lv5 as 
	case 
		when src_avt_key in(3,6,8) then '아바타'
		when src_avt_key in(1,2,4) then '테스트'
		else '기타' end
}}}

{{{
alter table ods.poker.tournament
add std_dt as convert(date, begin_dt) persisted not null 
}}}