Re: SQL Injection Code Help

Dan Sullivan wrote:

A parameter used in a TOP statement must be in parantheses.

DECLARE @n INT
SET @n = 2
SELECT TOP(@n) * From #tbl

Dan

Thanks, you live and learn :)

PL.

.

References:
- Re: SQL Injection Code Help
  - From: pblse2
- Re: SQL Injection Code Help
  - From: Dan Sullivan

Relevant Pages

Re: resultset of proc in another proc
... i want to use the result set from a stored proc in another stored proc, ... declare @tbl (y1 int, y2 int) ...
(comp.databases.ms-sqlserver)
Re: Add bulk info
... @start_num int, ... declare @num int ... select * from #tbl ...
(microsoft.public.sqlserver.programming)
Re: Really tough ADO Stored Procedure Question. Please Help!!!
... @lScenarioID_CopyFrom int, ... DECLARE @ErrMSG varchar--This is the max msg size ... ROLLBACK TRANSACTION ... SELECT @lRowCountHolder = MIN ...
(microsoft.public.sqlserver.odbc)
Re: Really tough ADO Stored Procedure Question. Please Help!!!
... @lScenarioID_CopyFrom int, ... DECLARE @ErrMSG varchar--This is the max msg size ... ROLLBACK TRANSACTION ... SELECT @lRowCountHolder = MIN ...
(microsoft.public.sqlserver.programming)
Re: Really tough ADO Stored Procedure Question. Please Help!!!
... @lScenarioID_CopyFrom int, ... DECLARE @ErrMSG varchar--This is the max msg size ... ROLLBACK TRANSACTION ... SELECT @lRowCountHolder = MIN ...
(microsoft.public.sqlserver.server)