C# SQL Top as parameter

SELECT TOP (@topparam) * from table1

sql sql-server tsql ado.net

You need to have at least SQL Server 2005. This code works fine in 2005/8 for example ...

DECLARE @iNum INTSET @iNum = 10SELECT TOP (@iNum) TableColumnIDFROM TableName

If you have SQL Server 2000, give this a try ...

CREATE PROCEDURE TopNRecords@intTop INTEGERASSET ROWCOUNT @intTopSELECT * FROM SomeTableSET ROWCOUNT 0GO

sql sql-server tsql ado.net

You could write an inline query:

EXEC 'SELECT TOP ' + @topparam + ' * FROM ... '

Parse it as an int and that will prevent a SQL injection attack.

CodeHunter