Answer Posted / smart bro

XP stands for extended store procedure

What are the different kinds of ssrs reports?

214

---

What is a user-defined function in the sql server and what is its advantage?

1106

---

What is the difference function and stored procedure?

1065

---

How to scale out a federation by Sql statement?

116

---

What is model database in sql server?

1056

---

What is the primary use of the model database?

1089

---

How to insert multiple rows with one insert statement in ms sql server?

1131

---

what exactly sql injuction.how to overcome.....

2547

---

What are the approximate numeric data types?

942

---

Why we use trigger in sql server with example?

965

---

What is the name of reporting services config file and what’s it’s used for?

146

---

What is normalization? Describe its different types.

1106

---

What is raid? : SQL Server Architecture

1183

---

How to create a stored procedure with a statement block in ms sql server?

1071

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

988

---