Sample Header Ad - 728x90

Does Sql Server caches parameterized anonymous blocks?

0 votes
1 answer
104 views
"Anonymous block" is a term from Oracle. But speaking of the thing for sql server
sql
Declare
   ....
Begin
    begin trans
 . . . 
    commit
End
If I send this SQL in parameterized form to the server via ADO.NET, will it be cached and reused or it will be recompiled every time?
Asked by T.S. (216 rep)
Feb 8, 2021, 07:12 PM
Last activity: Feb 8, 2021, 07:48 PM