_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
FrontPage › RowConstructors
|
|
覯 Row襯 ロ . 讌 襯 覲企 危願 觜襯企.
use tempdb go --drop table source_table create table source_table ( id varchar(10) , pw varchar(10) ); --drop table target_table create table target_table ( id varchar(10) , pw varchar(10) ); --drop table audit create table audit( action varchar(50) , insert_id varchar(10) , insert_pw varchar(10) , delete_id varchar(10) , delete_pw varchar(10) ); insert source_table values ('dwa', '1234') , ('yasi', '4567') , ('lk', 'lk123'); --new syntax, T-SQL Row Constructors go /*谿瑚襦 企郁 螳ロ. select * from ( values ('dwa', '1234') , ('yasi', '4567') , ('lk', 'lk123') ) t(id, passwd) ;with test as ( select * from ( values (1, 'aaa') , (2, 'bbb') ) t (id, name) ) select * from test a cross join (values (1), (2)) b (id) */
鏤
|
讌朱 覲牛伎る 蠍磯 覦覯 覦蟆 企. (覦伎) |