Analogue of LOCK TABLES and UNLOCK TABLES for MS SQL?

B

B

biryukovm2020-04-23 13:24:14

SQL Server

biryukovm, 2020-04-23 13:24:14

Analogue of LOCK TABLES and UNLOCK TABLES for MS SQL?

Hi all.
I use LOCK TABLES and UNLOCK TABLES locks in MySQL, because I work in a lot of record processing thread so that there are no duplicates.
But now the task is to flick on MS SQL, and here I don’t know how to do it, tell me how to properly lock the list of tables to work like LOCK TABLES

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

V

Vitaly Rybchenko2015-09-02 16:55:21

How to replace MS Report Service? 2Reply

N

Nevars2015-09-18 12:53:02

How to query a table whose link is stored in another table? 2Reply

A

Anton Boyarshinov2017-09-27 18:54:47

How to get return value from procedure in CodeIgniter? 2Reply

D

DVoropaev2017-09-29 10:22:49

How to work in sqlcmd under linux? 1Reply

E

Evgeny Orlov2017-09-29 18:39:58

How to make table joins in SQL not "hard"? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question