[SQL Map] What does HandleParams do ?

Back to Forums

Leo de Oliveira

Solved

Question

Forge

What does HandleParams do?

27 May 2015

Paulo Ramos

Staff

Solution

Hi Leo!

It just adds some placeholders for defining local variables, in case you're testing your query in SQL Management Studio (or other client). It only affects queries having input parameters.

For example:

select * from {USER} where {USER}.[Id] = @UserId

will be converted to:

--SQLMap Params: Begin--

/* ToDo: fill parameter types and values */

declare @UserId

set @UserId =

--SQLMap Params: End--

select * from ossys_user where ossys_user.[Id] = @UserId

You still have to enter the variables types and values when testing.

28 May 2015

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines