SQL Server优化:SQL Server中Nolock关键字的用法

复制CREATETABLE [dbo].[userInfo] ( [id] varchar(32) COLLATE Chinese_PRC_CI_AS NOTNULL,键字 [userName] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL, [birthday] [dbo].[birthday] NULL, CONSTRAINT [PK__userInfo__3213E83F0505C75D] PRIMARYKEY CLUSTERED ([id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO INSERTINTO [dbo].[userInfo] ([id], [userName], [birthday]) VALUES (123, N小明, 2005-01-02 12:30:00.000); INSERTINTO [dbo].[userInfo] ([id], [userName], [birthday]) VALUES (125, N小孙, 2005-01-02 12:30:00.000); 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.