how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

---

What is ms sql server service broker?

0 Answers  

---

What is efficiency data?

0 Answers  

---

How to create a ddl trigger using "create trigger" statements?

0 Answers  

---

What is difference between delete & truncate commands?

0 Answers  

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

---

What happens when converting big values to numeric data types?

0 Answers  

---

What is the difference between primary key and unique constraints?

0 Answers  

---

What is rtm version in sql server?

0 Answers  

---

How to delete database objects with "drop" statements in ms sql server?

0 Answers  

---

Explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---