I'm using
Do I need to use TRANSACTIONs when I have multiple SQL statements (CREATE, UPDATE, DELETE) in my post-deployment scripts? When I look at our deployment script generated by SSDT, from what I can tell, SSDT only uses transactions for SQL that it generates based on the diff script.
If you want all operations to be rolled back if any of them fail, wrap all operations in a single transaction. Otherwise, if any of them encounter a failure that operation will stop and any previous changes will remain. Otherwise you can just end each operation with a semicolon for clarity, though SQL Server doesn't require it (yet).