_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 螻磯貉朱り鍵

Contents



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 
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

瑚 覈旧朱 る 蠏碁 觜讌 蟆企. 讌襷 蠏碁ゼ 覩碁 螳ロ 覈旧朱 覦朱慨 蠏碁覃 蠏碁 襷襦 蠏碁 蟆企. (蟯危)