Question

存储过程的写法

use test
go
create proc page
(
@start int,
@pagetop int)
as
begin
declare @sql varchar(max);
set
@sql='select top @start * from test1 where id not in (select top @page * from test1 order by id) order by id'
exec(@sql)
end
..............................................
public DataSet page(int size,int top)
{
this.open();
SqlCommand com = new SqlCommand("page",conn);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add(new SqlParameter("@start",size));
com.Parameters.Add(new SqlParameter("@pagetop",top));
SqlDataAdapter da = new SqlDataAdapter(com);

DataSet ds = new DataSet();
da.Fill(ds);
return ds;
this.close();

}
.....................................
--------------------------------------------------------------------------------

错误：当没有用 EXISTS 引入子查询时，在选择列表中只能指定一个表达式。

采纳加分！~~~~~~~~~~~~~~~

Answer 1

SELECT后面的查询列里的子查询可能存在多个值

所以会报错

where id not in (select top @page * from test1 order by id) order by id'

就是where 后面的id 在你后面的查询中有多个值

Answer 2

Parameters 没有给值么？