CREATE TABLE [dbo].[Test_Log](  [AppName] nvarchar(128) NULL,  [Sql] varchar(max) NULL,  [UserName] [nvarchar](60) NULL,  [HostName] nvarchar(128)  NULL,  [Time] [datetime] NULL ) ON [PRIMARY]

select top 1 * from T  For Update NoWait select top 1 * from T with (UPDLOCK,nowait)

SET LANGUAGE N'Simplified Chinese' select CONVERT(VARCHAR(19),GETDATE()) SET LANGUAGE N'English' select CONVERT(VARCHAR(19),GETDATE())