Who developed sql server?

0 Answers  

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

Delete duplicate rows without using rowid.

0 Answers   Nagarro,

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---

---

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

---

How to Rebuild Master database in sql server 2005.

2 Answers   Wipro,

---

How can I know what locks are running on which resource?

0 Answers  

---

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

Explain primary key?

0 Answers  

---

How to create a Master database in SQL server ?

0 Answers   MCN Solutions,

---