Notice
Recent Posts
Recent Comments
목록Merge사용법 (1)
분노의 챔질
반응형
[MSSQL] Merge사용
declare @Test table ( EmployeeID nvarchar(10), EmployeeName nvarchar(30) ) insert @Test select '1', '김' union all select '209001', '홍' select * from @Test declare @TestInfo table ( RowStatus nvarchar(10), EmployeeID nvarchar(10), EmployeeName nvarchar(30) ) insert @TestInfo select 'Modified', '209001', '홍길동' union all select 'Added', '209002', '갑돌이' union all select 'Deleted', '1', '김' merge @Te..
Programming/SQL
2010. 3. 31. 09:19
반응형