Answer Posted / harninder

select `salary` from test t1 where 0=(select count(*) from
test where t1.`salary`<`salary`)

What is sql server schema compare? How we can compare two database schemas?

664

---

What is primary key and example?

594

---

Which trace flags are enabled in sql server?

593

---

Tell me what is sql profiler?

723

---

What is the difference between an index and a unique index?

639

---

---

Can you move the resources after pausing the node? : sql server database administration

674

---

do views contain data ?

665

---

What are sp_configure commands and set commands?

637

---

What different steps will a sql server developer take to secure sql server?

600

---

What are a scheduled jobs or what is a scheduled tasks?

570

---

How to configure odbc dsn with different port numbers?

663

---

What are different types of data sources?

564

---

What is user-defined inline table-valued function?

584

---

What is dynamic cursor in SQL SERVER?

633

---

What are dml (data manipulation language) statements in ms sql server?

630

---