求教啊!!!
CREATE PROC P_PageShow1@PageIndex int, -- 当前页数
@PageSize int -- 尺寸(每页显示的信息条数)
AS
BEGIN
DECLARE @SqlString nvarchar(2048)
SET @SqlString = 'SELECT TOP '
+ CAST(@PageSize AS nvarchar(8)) --cast类型转换
+' * FROM Employee'
+' WHERE EmployeeID'
+' NOT IN ' --第一页的不再第二页显示
+' (SELECT TOP '
+ CAST(((@PageIndex - 1) * @PageSize) AS nvarchar)
+' EmployeeID FROM Employee'
+' WHERE Dept = 销售部'
+' ) '
-- PRINT (@SqlString)
EXECUTE SP_EXECUTESQL @SqlString
END
GO
WHERE Dept = 销售部' 这老报错,为什么........... --------------------编程问答-------------------- 销售部 是字段值,不是变量,要用引号引起来 --------------------编程问答-------------------- Dept = "销售部"' --------------------编程问答-------------------- 认同,加引号
补充:企业软件 , ERP/CRM