時間:2024-03-09 11:51作者:下載吧人氣:21
測試環境準備
create table #table1create table #table2
( id int , name varchar(20) );
go
insert into #table1 ( id, name ) values ( 1, ‘a’ ), ( 2, null ), ( 3, ‘c’ ), ( 4, ‘d’ ), ( 5, ‘e’ );
insert into #table2 ( id, name ) values ( 1, ‘a1’ ), ( 2, ‘b1’ ), ( 3, ‘c1’ );
網友評論