随笔分类 -  SQL

摘要：代码部分过程部分:View Code CREATE procedure [dbo].[WS_GetKbDoc]@KBTypeID int,@Keyword nvarchar(50),@pagesize int,@pageindex intasbegin with temptbl as ( SELECT ROW_NUMBER() OVER (ORDER BY d.CreatedDate desc)AS RowNum, d.*,s.StaffName,s.StaffNo,k.KBTypeName from dbo.WS_Document d left join dbo.WS_Staff s ... 阅读全文