Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Demo <> Inner join Delete in SQL Server

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 14, rows affected: 8, absolute service time: 0,23 sec, absolute service time: 0,23 sec 
edit mode |  history 
  
sql server version



1
Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86) 
	Feb 20 2014 19:20:46 
	Copyright (c) Microsoft Corporation
	Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)






  
EmployeeRun
empWorkNo



1
1
EMW101



2
2
EMW102



3
3
EMW103



4
4
EMW104



5
5
EMW105





  
EmployeeNo
empWorkNo
company
createdDate



1
1
EMW101
1
07.02.2019 07:12:00



2
2
EMW103
2
07.02.2019 07:12:00





  
EmployeeRun
empWorkNo



1
2
EMW102



2
3
EMW103



3
4
EMW104



4
5
EMW105





  
EmployeeNo
empWorkNo
company
createdDate



1
1
EMW101
1
07.02.2019 07:12:00



2
2
EMW103
2
07.02.2019 07:12:00






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development