日期:2014-05-16 浏览次数:20681 次
exec sp_executesql N'SELECT TOP (10)
[Project1].[ID] AS [ID],
[Project1].[UID] AS [UID],
[Project1].[Name] AS [Name],
[Project1].[Email] AS [Email],
[Project1].[Title] AS [Title],
[Project1].[Content] AS [Content],
[Project1].[ImageSrc] AS [ImageSrc],
[Project1].[ThImageSrc] AS [ThImageSrc],
[Project1].[IP] AS [IP],
[Project1].[PostDateTime] AS [PostDateTime],
[Project1].[UpdateDateTime] AS [UpdateDateTime],
[Project1].[ForumID] AS [ForumID],
[Project1].[ParentID] AS [ParentID]
FROM ( SELECT [Project1].[ID] AS [ID], [Project1].[UID] AS [UID], [Project1].[Name] AS [Name], [Project1].[Email] AS [Email], [Project1].[Title] AS [Title], [Project1].[Content] AS [Content], [Project1].[ImageSrc] AS [ImageSrc], [Project1].[ThImageSrc] AS [ThImageSrc], [Project1].[IP] AS [IP], [Project1].[PostDateTime] AS [PostDateTime], [Project1].[UpdateDateTime] AS [UpdateDateTime], [Project1].[ForumID] AS [ForumID], [Project1].[ParentID] AS [ParentID], row_number() OVER (ORDER BY [Project1].[UpdateDateTime] DESC) AS [row_number]
FROM ( SELECT
[Extent1].[ID] AS [ID],
[Extent1].[UID] AS [UID],
[Extent1].[Name] AS [Name],
[Extent1].[Email] AS [Email],
[Extent1].[Title] AS [Title],
[Extent1].[Content] AS [Content],
[Extent1].[ImageSrc] AS [ImageSrc],
[Extent1].[ThImageSrc] AS [ThImageSrc],
[Extent1].[IP] AS [IP],
[Extent1].[PostDateTime] AS [PostDateTime],
[Extent1].[UpdateDateTime] AS [UpdateDateTime],
[Extent1].[ForumID] AS [ForumID],
[Extent1].[ParentID] AS [ParentID]
FROM [dbo].[Thread] AS [Extent1]
WHERE ([Extent1].[ForumID] = @p__linq__0) AND (@p__linq__0&nbs