What is pivot and unpivot?

0 Answers  

---

What is checkpoint process in the sql server?

0 Answers  

---

what are the critical issues you have resloved in your company

0 Answers   Wipro,

---

What is the difference between functions and scalar functions?

0 Answers   EXL,

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

What happens if null values are involved in comparison operations?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What are the benefits of filtered indexes?

0 Answers  

---

what is procedure in sql?

2 Answers   Millennium, SQL,

---

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

---

Why would you use sql agent?

0 Answers  

---