DataBaser.Net: 계산된컬럼만들기

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

Retrieved from http://databaser.net/moniwiki/wiki.php/계산된컬럼만들기
last modified 2018-04-13 23:12:52

Contents