Hi,
I'd like to know if I'm able to use a CTE inside a transaction block like so:
BEGIN TRANSACTION
WITH CTE .....
SELECT.....etc.
COMMIT TRANSACTION
Any insight will be appreciated.
Thanks,
S
asked
Can you use a CTE inside a transaction block?
yes you can use a CTE within a transaction, the only point I would make is that you need to inlcude the ';' statement terminator
i.e.
BEGIN TRANSACTION
;WITH CTE .....
SELECT.....etc.
COMMIT TRANSACTION
