SET SHOWPLAN_TEXT ON
GO
SELECT TOP 1000
[Username]
,[PasswordHash]
,[Email]
,[PhoneNumber]
,[IsFirstTimeLogin]
,[AccessFailedCount]
,[CreationDate]
,[IsActive]
FROM [Test].[dbo].[CICUser] usr inner join [Test].dbo.CICUserRole rol on usr.UserId=rol.UserId
set statistics profile on go SELECT TOP 1000 [Username] ,[PasswordHash] ,[Email] ,[PhoneNumber] ,[IsFirstTimeLogin] ,[AccessFailedCount] ,[CreationDate] ,[IsActive] FROM [Test].[dbo].[CICUser] usr inner join [Test].dbo.CICUserRole rol on usr.UserId=rol.UserId
转载请注明原文地址: https://ju.6miu.com/read-678043.html
