![]() ![]() Making use of nolock as below will avoid deadlock but there are chances that you may not get the recent records just insert in your DB.Ģ) When you are using two or more databases then the things are going to be complicated, because DB1 will be in use to operate queries within itself(related to DB1) And DB2 is requesting DB1 to fire some queries(e.g: via Triggers). #DEADLOCK FOUND WHEN TRYING TO GET LOCK UPDATE#I'll extract the queries out of the transaction, so it will contain only INSERT and UPDATE sentences.ġ) Yes, a query(SELECT/INSERT/UPDATE/DELETE) can lock the database.įor Example: SELECT Query SELECT * FROM CUSTOMER
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |