CREATE Proc ExecOder
(
@condition varchar(200),
@count int output
)
As
declare @page varchar(300)
set @page = 'select ' + Cast(@count as varchar) + '=count(*) from testPage where ' + @condition
Exec(@page)
GO
我的本意是根据输入的条件,查出数据库中有多少条对应的记录.
可执行下来好象不对.不报错!也好象没返回结果,这是怎么回事呢?
|
#2
棉花糖ONE2006-12-08 12:57
|
|
|
#3
NqIceCoffee2006-12-08 13:16
|
|
#4
bygg2006-12-08 14:02
|
|
|
#5
棉花糖ONE2007-03-01 22:11
|