Explain “row_number()” in sql server with an example?

0 Answers  

---

How can a user-defined datatype be created?

0 Answers  

---

How do you create type- insensitive operator?

0 Answers   EXL,

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

How do you troubleshoot SQL Server if its running very slow?

2 Answers   HP,

---

How to create prepared statements using odbc_prepare()?

0 Answers  

---

How to delete an existing row with delete statements in ms sql server?

0 Answers  

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

0 Answers  

---

What is Outter Join?

1 Answers  

---

Explain primary key and foreign key constraints?

0 Answers  

---

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

---

Do you know what are various aggregate functions that are available?

0 Answers  

---