UC知道这句SQL错哪了？
来源：百度知道 编辑：UC知道 时间：2024/05/26 12:56:40
SQL SERVER2000 建存储过程如下
CREATE PROCEDURE
@PTable varchar(20)
AS
select top 10 UID from [@PTable] where UID>(select max(UID)
from (select top 20 UID from [@PTable]))
然后总是报错')'附近有语法错误，不知道错哪了，大家帮忙
CREATE PROCEDURE
@PTable varchar(20)
AS
select top 10 UID from [@PTable] where UID>(select max(UID)
from (select top 20 UID from [@PTable]))
然后总是报错')'附近有语法错误，不知道错哪了，大家帮忙
CREATE PROCEDURE pro_table
@PTable varchar(20)
AS
begin
declare @sql varchar(1000)
set @sql='select top 10 UID from '+@PTable+' where UID>(select max(UID)
from '+@PTable+' where uid in(select top 1 uid from '+@PTable+')) '
end
exec (@sql)
下面执行。。。。exec pro_table 看看是你要的效果么