If we edit a stored procedure, it is recompiled the very first time it is executed. So the program using this Stored Procedure may see delay during this period (as it is being recompiled).
But we can force SQL Server to recompile Stored Procedure by using WITH RECOMPILE option
Example:exec usp_TestProcedure WITH RECOMPILE
Subscribe to:
Post Comments (Atom)
-
Grid is a layout panel that consists of rows and columns. Example 1: < Grid > < Grid.RowDefinitions > < Row...
-
Label tb = new Label (); tb.Name = "LabelID" + iRow; tb.Content = lblName; Grid .SetColumn(tb, iCol); Grid .SetRow(tb,...
-
HttpClient is a .NET class that an app can use to send HTTP requests and receive HTTP responses from a REST web service. The resources that...
No comments:
Post a Comment