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