Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2014
>>
>>I think you don't need any parameters like holdlock or rowlock between begin and end tran. But you have to use begin/end trans carefully. You may cause deadlock.
>
>Hi, Metin, not to be picky, but in SQL Server it's "BEGIN TRANS/COMMIT TRANS (or ROLLBACK TRANS)". "BEGIN/END" are simply to delimit blocks of code.
Hi Kevin,
OK, thank you. I was a VFP developer and now a Axapta developer so I never touched SQL in directly so much, but however I should be aware for this... :)
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement