第一种
exec sp_executesql N'SELECT [u].[Id], [u].[LoginName], [u].[KSH], [u].[TrueName], [u].[Sex], [u].[CollegeName], [u].[ProjectName], [u].[CardId], [t].[OkEndTime], [t].[Status], [t].[Remark], [u].[ReportYear], [u].[CreateDate]
FROM [WNA_NewUser] AS [u]
LEFT JOIN (
SELECT [u0].*
FROM [WNA_EnrolmentReport] AS [u0]
) AS [t] ON [u].[Id] = [t].[UserId]
WHERE (0 1) AND ([u].[Sex] = @__param_Sex_0)
ORDER BY [u].[CreateDate] DESC
OFFSET @__p_1 ROWS FETCH NEXT @__p_2 ROWS ONLY',N'@__param_Sex_0 nvarchar(10),@__p_1 int,@__p_2 int',@__param_Sex_0=N'男',@__p_1=0,@__p_2=10
第二种
exec sp_executesql N'SELECT [a].[Id], [a].[LoginName], [a].[KSH], [a].[TrueName], [a].[Sex], [a].[CollegeName], [a].[ProjectName], [a].[CardId], [b].[OkEndTime], [b].[Status], [b].[Remark], [a].[ReportYear], [a].[CreateDate]
FROM [WNA_NewUser] AS [a]
LEFT JOIN [WNA_EnrolmentReport] AS [b] ON [a].[Id] = [b].[UserId]
WHERE (0 1) AND ([a].[Sex] = @__param_Sex_0)
ORDER BY [a].[CreateDate] DESC
OFFSET @__p_1 ROWS FETCH NEXT @__p_2 ROWS ONLY',N'@__param_Sex_0 nvarchar(10),@__p_1 int,@__p_2 int',@__param_Sex_0=N'男',@__p_1=0,@__p_2=10
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/1591/viewspace-3150440/ ，如需转载，请注明出处，否则将追究法律责任。
