Answer Posted / rajendra prasad reddy penumall

select salary=max(salart)from from EmpMaster

Mention the different types of replication in sql server.

962

---

Define left outer join in sql server joins?

908

---

Tell me about pre-defined functions of sql?

1072

---

Write the syntax for stuff function in an sql server?

979

---

Why should you use or avoid select * statements?

969

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1070

---

What is a join in sql?

1020

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

892

---

What is dirty page?

921

---

How to connect sql server management studio express to sql server 2005 express?

969

---

What is user defined stored procedures?

880

---

What is the difference between composite index and covering index?

902

---

what is a join and explain different types of joins? : Sql server database administration

913

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

951

---

What are the different types of stored procedures?

1069

---