更新时间:2022-09-18 13:31:01
/*example 1*/ SELECT * FROM [dbo].[customer] SELECT * FROM [dbo].[customer] WHERE id=1 SELECT * FROM [dbo].[customer] WHERE id=2 SELECT * FROM [dbo].[customer](NOLOCK) WHERE id=2
分别执行后的结果(结果里空白的为阻塞状态)
SELECT * FROM [dbo].[customer]