> > >

Microsoft SQL Server MCQs

What is the "WITH RECOMPILE" statement used for?

Converts a SQL statement into machine code

Causes the SQL engine to recompile itself from source

Causes SQL Server to rebuild the query plan for a stored procedure on every call

Binds a CLR static method to a stored procedure

Answer

Correct Answer: Causes SQL Server to rebuild the query plan for a stored procedure on every call

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it