OKay I have this stored procedure which looks like this
CREATE procedure dbo.tenrows
@tenrows as int
as
SELECT *
FROM pairs
WHERE (orderkey < @tenrows)
GO
Now I want @tenrows to equal 10, But I was thinking I could do this somehow in .Net, For example a command button in aspx, Is it possible to add on the number 10 every time I click a button, Cause Right now it won't work because I have no value assigned to a parameter, ? ANy Help?
CREATE procedure dbo.tenrows
@tenrows as int
as
SELECT *
FROM pairs
WHERE (orderkey < @tenrows)
GO
Now I want @tenrows to equal 10, But I was thinking I could do this somehow in .Net, For example a command button in aspx, Is it possible to add on the number 10 every time I click a button, Cause Right now it won't work because I have no value assigned to a parameter, ? ANy Help?