Why and when do stored procedure recompile?

Question Posted / sandeeep kumar

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

What do you understand by a view? What does the with check option clause for a view do?

what is a self join? Explain it with an example? : Sql server database administration

List the data types available in mssql?

What is the difference between value type and reference type?

How can we check the sql server version?

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

What are the types of joins in sql?

What are the different types of Indexes available in SQL Server?

What is trigger and different types of Triggers?

How to write a query with an inner join in ms sql server?

Can we use custom code in ssrs?

What is #temp and @table variable in SQL server?

For more SQL Server Interview Questions Click Here