1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Which is faster statement or preparedstatement?

Question Posted / ram singh


Which is faster statement or preparedstatement?..

Answer / Desh Deepak

PreparedStatement is generally faster compared to Statement in SQL Server. The main reason is that PreparedStatements are compiled and optimized by the server before they're executed, while Statements are compiled every time they're executed.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the difference between upgrade and migration in sql server?

0 Answers  

Can you explain different types of joins?

1 Answers  

What are examples of triggers?

1 Answers  

select names starts with a,b,c

8 Answers   Scope International,

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

What are the differences between ms sql server & oracle?

1 Answers  

Can multiple columns be used in sql group by clause in ms sql server?

1 Answers  

How to list all user defined functions in the current database?

1 Answers  

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

What is optimistic concurrency?

1 Answers  

What are the advantages of using a stored procedure?

1 Answers  

How to insert data with null values?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories