Answer / Devesh Sharma

"Table Value Parameters (TVP)" is a feature in SQL Server that allows a user to pass multiple rows of data as a single parameter to a stored procedure. TVPs improve performance when passing large amounts of data by reducing the number of round trips between the client and the server, as well as minimizing memory consumption.

how can you check the level of fragmentation on a table? : Sql server administration

1 Answers  

---

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---

what is a check constraint?

1 Answers  

---

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

1 Answers  

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

Explain difference between cross join and full outer join?

1 Answers  

---

what is trigger

1 Answers   CarrizalSoft Technologies, NIIT,

---

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,

---

Are connections to sql server encrypted?

1 Answers  

---

How do I find my localdb version?

1 Answers  

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

What are the tables in sql?

1 Answers  

---