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
Last activity: Feb 8, 2021, 07:48 PM