What is faster for multiple SQL calls — parameterized queries or stored procedures?

Question

I am using SQL Server 2005. I am looking for opening an SQL connection, looping the collection and running the update request (stored procedure or parameterized query) with the data from the collection item, and then closing the connection.

What will give me the best performance and why?

Answer 1

It’s hard to say with certainty, since there are a number of factors that can affect performance. Theoretically, the stored procedure method should be faster.

, XML , . , , XML. Xquery, Open XML sp_XML_preparedocument XML .

Answer 2

SQL- . , .

.

, ( 1 2), . .

" proc", , . LINQ .

( ) , , . , , procs ( ) .

Answer 3

. , , , , , . , , DBA, , , , , , .

Answer 4

- . , , . , , . , , , SQL , . , SQL, .

Answer 5

( ), , .

, :

• SqlCommand /.
• SqlParameter , , Parameters .
• Prepare .
• , .

Answer 6

Usually stored procedures because the server can pre-optimize the execution plan. Although a well-written parameterized query is better than a general stored procedure.