Answer Posted / krishh

SELECT max(salary) FROM Employee WHERE salary NOT IN (SELECT max(salary) FROM Employee);

Other than truncate statement, which other command can by-pass the trigger on the tables?

611

---

Do you know query execution plan?

580

---

What command do we use to rename a db, a table and a column?

496

---

What is outer join in sql server joins?

587

---

What is the new security features added in sql server 2014? : sql server security

556

---

---

Explain about SQLOS?

575

---

How to configure odbc dsn with different port numbers?

552

---

1 01 101 01010

1554

---

Explain in details security in SQL azure?

97

---

How can delete duplicate records in cte in sql server?

507

---

What are the tool windows in sql server management studio? : sql server management studio

610

---

How to start sql server browser service?

550

---

Can you explain what is indexed view? How to create it?

515

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

502

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

526

---