CTE总是报错.Must declare the table variable "@tablename".
CTE总是报错.Must declare the table variable "@tablename".
declare @tablename nvarchar(50)
set @tablename = '222';
WITH PAGE_CTE
as
(
SELECT CEILING((ROW_NUMBER() OVER (ORDER BY Dpid ASC))/2) AS PageNumber,* FROM @tablename
)
select Dpid,DpBlock from PAGE_CTE where PageNumber=1
declare @tablename nvarchar(50)
set @tablename = '222';
WITH PAGE_CTE
as
(
SELECT CEILING((ROW_NUMBER() OVER (ORDER BY Dpid ASC))/2) AS PageNumber,* FROM @tablename
)
select Dpid,DpBlock from PAGE_CTE where PageNumber=1
赞
可能相似的问题
-
1年前1个回答
-
1年前1个回答
-
1年前1个回答
-
1年前3个回答
-
1年前1个回答
你能帮帮他们吗