Hi all

While in Oracle escaping apostrophe (') character
seems to be enough protection for Sql Injection (I
think is not), this is not true for Sql Server. Here a
little example I think many of you will find useful.

For an on-the-fly query like:
Query = "select field1, field2... from table where id
= '" + FixSQL (FieldValue) + "'"

Where FixSQL will escape single quotes AKA apostrophe,
the following value for "FieldValue" will be
effective:

FieldValue = "(NewLine)GO(NewLine)Desired Sql
Sentence(NewLine)GO"

Final result is:
select field1, field2... from table where id = '
GO
Desired Sql Sentence
GO
'

Here the MS Documentation for GO Keyword:
<snip>
SQL Server utilities interpret GO as a signal that
they should send the current batch of Transact-SQL
statements to SQL Server. The current batch of
statements is composed of all statements entered since
the last GO, or since the start of the ad hoc session
or script if this is the first GO
</snip>

So one sentence become three, sentences one and three
will fail, but sentence two (the one of our interest)
will execute successfully.

Hope you find this interesting

Cheers,
-JC

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

[ reply ]

Hi all<br/>
<br/>
While in Oracle escaping apostrophe (') character<br/>
seems to be enough protection for Sql Injection (I<br/>
think is not), this is not true for Sql Server. Here a<br/>
little example I think many of you will find useful.<br/>
<br/>
For an on-the-fly query like:<br/>
Query = "select field1, field2... from table where id<br/>
= '" + FixSQL (FieldValue) + "'"<br/>
<br/>
Where FixSQL will escape single quotes AKA apostrophe,<br/>
the following value for "FieldValue" will be<br/>
effective:<br/>
<br/>
FieldValue = "(NewLine)GO(NewLine)Desired Sql<br/>
Sentence(NewLine)GO"<br/>
<br/>
Final result is:<br/>
select field1, field2... from table where id = '<br/>
GO<br/>
Desired Sql Sentence<br/>
GO<br/>
'<br/>
<br/>
Here the MS Documentation for GO Keyword:<br/>
<snip><br/>
SQL Server utilities interpret GO as a signal that<br/>
they should send the current batch of Transact-SQL<br/>
statements to SQL Server. The current batch of<br/>
statements is composed of all statements entered since<br/>
the last GO, or since the start of the ad hoc session<br/>
or script if this is the first GO<br/>
</snip><br/>
<br/>
So one sentence become three, sentences one and three<br/>
will fail, but sentence two (the one of our interest)<br/>
will execute successfully.<br/>
<br/>
Hope you find this interesting<br/>
<br/>
Cheers,<br/>
-JC<br/>
<br/>
_________________________________________________________<br/>
Do You Yahoo!?<br/>
Información de Estados Unidos y América Latina, en Yahoo! Noticias.<br/>
Visítanos en http://noticias.espanol.yahoo.com

[ reply ]

Hi all<br/><br/>
<br/><br/>
While in Oracle escaping apostrophe (') character<br/><br/>
seems to be enough protection for Sql Injection (I<br/><br/>
think is not), this is not true for Sql Server. Here a<br/><br/>
little example I think many of you will find useful.<br/><br/>
<br/><br/>
For an on-the-fly query like:<br/><br/>
Query = "select field1, field2... from table where id<br/><br/>
= '" + FixSQL (FieldValue) + "'"<br/><br/>
<br/><br/>
Where FixSQL will escape single quotes AKA apostrophe,<br/><br/>
the following value for "FieldValue" will be<br/><br/>
effective:<br/><br/>
<br/><br/>
FieldValue = "(NewLine)GO(NewLine)Desired Sql<br/><br/>
Sentence(NewLine)GO"<br/><br/>
<br/><br/>
Final result is:<br/><br/>
select field1, field2... from table where id = '<br/><br/>
GO<br/><br/>
Desired Sql Sentence<br/><br/>
GO<br/><br/>
'<br/><br/>
<br/><br/>
Here the MS Documentation for GO Keyword:<br/><br/>
<snip><br/><br/>
SQL Server utilities interpret GO as a signal that<br/><br/>
they should send the current batch of Transact-SQL<br/><br/>
statements to SQL Server. The current batch of<br/><br/>
statements is composed of all statements entered since<br/><br/>
the last GO, or since the start of the ad hoc session<br/><br/>
or script if this is the first GO<br/><br/>
</snip><br/><br/>
<br/><br/>
So one sentence become three, sentences one and three<br/><br/>
will fail, but sentence two (the one of our interest)<br/><br/>
will execute successfully.<br/><br/>
<br/><br/>
Hope you find this interesting<br/><br/>
<br/><br/>
Cheers,<br/><br/>
-JC<br/><br/>
<br/><br/>
_________________________________________________________<br/><br/
>
Do You Yahoo!?<br/><br/>
Información de Estados Unidos y América Latina, en Yahoo! Noticias.<br/><br/>
Visítanos en http://noticias.espanol.yahoo.com

[ reply ]

Hi all<br/><br/><br/>
<br/><br/><br/>
While in Oracle escaping apostrophe (') character<br/><br/><br/>
seems to be enough protection for Sql Injection (I<br/><br/><br/>
think is not), this is not true for Sql Server. Here a<br/><br/><br/>
little example I think many of you will find useful.<br/><br/><br/>
<br/><br/><br/>
For an on-the-fly query like:<br/><br/><br/>
Query = "select field1, field2... from table where id<br/><br/><br/>
= '" + FixSQL (FieldValue) + "'"<br/><br/><br/>
<br/><br/><br/>
Where FixSQL will escape single quotes AKA apostrophe,<br/><br/><br/>
the following value for "FieldValue" will be<br/><br/><br/>
effective:<br/><br/><br/>
<br/><br/><br/>
FieldValue = "(NewLine)GO(NewLine)Desired Sql<br/><br/><br/>
Sentence(NewLine)GO"<br/><br/><br/>
<br/><br/><br/>
Final result is:<br/><br/><br/>
select field1, field2... from table where id = '<br/><br/><br/>
GO<br/><br/><br/>
Desired Sql Sentence<br/><br/><br/>
GO<br/><br/><br/>
'<br/><br/><br/>
<br/><br/><br/>
Here the MS Documentation for GO Keyword:<br/><br/><br/>
<snip><br/><br/><br/>
SQL Server utilities interpret GO as a signal that<br/><br/><br/>
they should send the current batch of Transact-SQL<br/><br/><br/>
statements to SQL Server. The current batch of<br/><br/><br/>
statements is composed of all statements entered since<br/><br/><br/>
the last GO, or since the start of the ad hoc session<br/><br/><br/>
or script if this is the first GO<br/><br/><br/>
</snip><br/><br/><br/>
<br/><br/><br/>
So one sentence become three, sentences one and three<br/><br/><br/>
will fail, but sentence two (the one of our interest)<br/><br/><br/>
will execute successfully.<br/><br/><br/>
<br/><br/><br/>
Hope you find this interesting<br/><br/><br/>
<br/><br/><br/>
Cheers,<br/><br/><br/>
-JC<br/><br/><br/>
<br/><br/><br/>
_________________________________________________________<br/><
br/<br/>
><br/>
Do You Yahoo!?<br/><br/><br/>
Información de Estados Unidos y América Latina, en Yahoo! Noticias.<br/><br/><br/>
Visítanos en http://noticias.espanol.yahoo.com

[ reply ]

Hi all<br/><br/><br/><br/>
<br/><br/><br/><br/>
While in Oracle escaping apostrophe (') character<br/><br/><br/><br/>
seems to be enough protection for Sql Injection (I<br/><br/><br/><br/>
think is not), this is not true for Sql Server. Here a<br/><br/><br/><br/>
little example I think many of you will find useful.<br/><br/><br/><br/>
<br/><br/><br/><br/>
For an on-the-fly query like:<br/><br/><br/><br/>
Query = "select field1, field2... from table where id<br/><br/><br/><br/>
= '" + FixSQL (FieldValue) + "'"<br/><br/><br/><br/>
<br/><br/><br/><br/>
Where FixSQL will escape single quotes AKA apostrophe,<br/><br/><br/><br/>
the following value for "FieldValue" will be<br/><br/><br/><br/>
effective:<br/><br/><br/><br/>
<br/><br/><br/><br/>
FieldValue = "(NewLine)GO(NewLine)Desired Sql<br/><br/><br/><br/>
Sentence(NewLine)GO"<br/><br/><br/><br/>
<br/><br/><br/><br/>
Final result is:<br/><br/><br/><br/>
select field1, field2... from table where id = '<br/><br/><br/><br/>
GO<br/><br/><br/><br/>
Desired Sql Sentence<br/><br/><br/><br/>
GO<br/><br/><br/><br/>
'<br/><br/><br/><br/>
<br/><br/><br/><br/>
Here the MS Documentation for GO Keyword:<br/><br/><br/><br/>
<snip><br/><br/><br/><br/>
SQL Server utilities interpret GO as a signal that<br/><br/><br/><br/>
they should send the current batch of Transact-SQL<br/><br/><br/><br/>
statements to SQL Server. The current batch of<br/><br/><br/><br/>
statements is composed of all statements entered since<br/><br/><br/><br/>
the last GO, or since the start of the ad hoc session<br/><br/><br/><br/>
or script if this is the first GO<br/><br/><br/><br/>
</snip><br/><br/><br/><br/>
<br/><br/><br/><br/>
So one sentence become three, sentences one and three<br/><br/><br/><br/>
will fail, but sentence two (the one of our interest)<br/><br/><br/><br/>
will execute successfully.<br/><br/><br/><br/>
<br/><br/><br/><br/>
Hope you find this interesting<br/><br/><br/><br/>
<br/><br/><br/><br/>
Cheers,<br/><br/><br/><br/>
-JC<br/><br/><br/><br/>
<br/><br/><br/><br/>
_________________________________________________________<br/><
<br/>
br/<br/><br/>
><br/><br/>
Do You Yahoo!?<br/><br/><br/><br/>
Información de Estados Unidos y América Latina, en Yahoo! Noticias.<br/><br/><br/><br/>
Visítanos en http://noticias.espanol.yahoo.com

[ reply ]

Hi all<br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/>
While in Oracle escaping apostrophe (') character<br/><br/><br/><br/><br/>
seems to be enough protection for Sql Injection (I<br/><br/><br/><br/><br/>
think is not), this is not true for Sql Server. Here a<br/><br/><br/><br/><br/>
little example I think many of you will find useful.<br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/>
For an on-the-fly query like:<br/><br/><br/><br/><br/>
Query = "select field1, field2... from table where id<br/><br/><br/><br/><br/>
= '" + FixSQL (FieldValue) + "'"<br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/>
Where FixSQL will escape single quotes AKA apostrophe,<br/><br/><br/><br/><br/>
the following value for "FieldValue" will be<br/><br/><br/><br/><br/>
effective:<br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/>
FieldValue = "(NewLine)GO(NewLine)Desired Sql<br/><br/><br/><br/><br/>
Sentence(NewLine)GO"<br/><br/><br/><br/><br
/>
<br/><br/><br/><br/><br/>
Final result is:<br/><br/><br/><br/><br/>
select field1, field2... from table where id = '<br/><br/><br/><br/><br/>
GO<br/><br/><br/><br/><br/>
Desired Sql Sentence<br/><br/><br/><br/><br/>
GO<br/><br/><br/><br/><br/>
'<br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/>
Here the MS Documentation for GO Keyword:<br/><br/><br/><br/><br/>
<snip><br/><br/><br/><br/><br/>
SQL Server utilities interpret GO as a signal that<br/><br/><br/><br/><br/>
they should send the current batch of Transact-SQL<br/><br/><br/><br/><br/>
statements to SQL Server. The current batch of<br/><br/><br/><br/><br/>
statements is composed of all statements entered since<br/><br/><br/><br/><br/>
the last GO, or since the start of the ad hoc session<br/><br/><br/><br/><br/>
or script if this is the first GO<br/><br/><br/><br/><br/>
</snip><br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/>
So one sentence become three, sentences one and three<br/><br/><br/><br/><br/>
will fail, but sentence two (the one of our interest)<br/><br/><br/><br/><br/>
will execute successfully.<br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/>
Hope you find this interesting<br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/>
Cheers,<br/><br/><br/><br/><br/>
-JC<br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/>
_________________________________________________________<br/><
<br/>
<br/><br/>
br/<br/><br/><br/>
><br/><br/><br/>
Do You Yahoo!?<br/><br/><br/><br/><br/>
Información de Estados Unidos y América Latina, en Yahoo! Noticias.<br/><br/><br/><br/><br/>
Visítanos en http://noticias.espanol.yahoo.com

[ reply ]

Hi all<br/><br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/><br/>
While in Oracle escaping apostrophe (') character<br/><br/><br/><br/><br/><br/>
seems to be enough protection for Sql Injection (I<br/><br/><br/><br/><br/><br/>
think is not), this is not true for Sql Server. Here a<br/><br/><br/><br/><br/><br/>
little example I think many of you will find useful.<br/><br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/><br/>
For an on-the-fly query like:<br/><br/><br/><br/><br/><br/>
Query = "select field1, field2... from table where id<br/><br/><br/><br/><br/><br/>
= '" + FixSQL (FieldValue) + "'"<br/><br/><br/><br/><br/><br/
>
<br/><br/><br/><br/><br/><br/>
Where FixSQL will escape single quotes AKA apostrophe,<br/><br/><br/><br/><br/><br/>
the following value for "FieldValue" will be<br/><br/><br/><br/><br/><br/>
effective:<br/><br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/><br/>
FieldValue = "(NewLine)GO(NewLine)Desired Sql<br/><br/><br/><br/><br/><br/>
Sentence(NewLine)GO"<br/><br/><br/><br/><
;br<br/>
/><br/>
<br/><br/><br/><br/><br/><br/>
Final result is:<br/><br/><br/><br/><br/><br/>
select field1, field2... from table where id = '<br/><br/><br/><br/><br/><br/>
GO<br/><br/><br/><br/><br/><br/>
Desired Sql Sentence<br/><br/><br/><br/><br/><br/>
GO<br/><br/><br/><br/><br/><br/>
'<br/><br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/><br/>
Here the MS Documentation for GO Keyword:<br/><br/><br/><br/><br/><br/>
<snip><br/><br/><br/><br/><br/><br/>

SQL Server utilities interpret GO as a signal that<br/><br/><br/><br/><br/><br/>
they should send the current batch of Transact-SQL<br/><br/><br/><br/><br/><br/>

statements to SQL Server. The current batch of<br/><br/><br/><br/><br/><br/>
statements is composed of all statements entered since<br/><br/><br/><br/><br/><br/>
the last GO, or since the start of the ad hoc session<br/><br/><br/><br/><br/><br/>
or script if this is the first GO<br/><br/><br/><br/><br/><br/>
</snip><br/><br/><br/><br/><br/><br/
>
<br/><br/><br/><br/><br/><br/>
So one sentence become three, sentences one and three<br/><br/><br/><br/><br/><br/>
will fail, but sentence two (the one of our interest)<br/><br/><br/><br/><br/><br/>
will execute successfully.<br/><br/><br/><br/><br/><br/
>
<br/><br/><br/><br/><br/><br/>
Hope you find this interesting<br/><br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/><br/>
Cheers,<br/><br/><br/><br/><br/><br/>
-JC<br/><br/><br/><br/><br/><br/>
<br/><br/><br/><br/><br/><br/>
_________________________________________________________<br/><
<br/>
<br/><br/>
<br/><br/><br/>
br/<br/><br/><br/><br/>
><br/><br/><br/><br/>
Do You Yahoo!?<br/><br/><br/><br/><br/><br/>
Información de Estados Unidos y América Latina, en Yahoo! Noticias.<br/><br/><br/><br/><br/><br/>
Visítanos en http://noticias.espanol.yahoo.com

[ reply ]

Hi all<br/><br/><br/><br/><br/><br/><br
/>
<br/><br/><br/><br/><br/><br/><br/>
While in Oracle escaping apostrophe (') character<br/><br/><br/><br/><br/><br/&
gt;<br/>
seems to be enough protection for Sql Injection (I<br/><br/><br/><br/><br/><br/><br/
>
think is not), this is not true for Sql Server. Here a<br/><br/><br/><br/><br/><br/><br/>

little example I think many of you will find useful.<br/><br/><br/><br/><br/><br/>
;<br/>
<br/><br/><br/><br/><br/><br/><br/>
For an on-the-fly query like:<br/><br/><br/><br/><br/><br/><
br/>
Query = "select field1, field2... from table where id<br/><br/><br/><br/><br/><br/><br/
>
= '" + FixSQL (FieldValue) + "'"<br/><br/><br/><br/><br/><
br/<br/>
><br/>
<br/><br/><br/><br/><br/><br/><br/>
Where FixSQL will escape single quotes AKA apostrophe,<br/><br/><br/><br/><br/><br
/><br/>
the following value for "FieldValue" will be<br/><br/><br/><br/><br/><br/><br/
>
effective:<br/><br/><br/><br/><br/><br/
><br/>
<br/><br/><br/><br/><br/><br/><br/>
FieldValue = "(NewLine)GO(NewLine)Desired Sql<br/><br/><br/><br/><br/><br/><br
/>
Sentence(NewLine)GO"<br/><br/><br/><br/><
;<br/>
;br<br/><br/>
/><br/><br/>
<br/><br/><br/><br/><br/><br/><br/>
Final result is:<br/><br/><br/><br/><br/><br/><br
/>
select field1, field2... from table where id = '<br/><br/><br/><br/><br/><br/><br/>

GO<br/><br/><br/><br/><br/><br/><br/
>
Desired Sql Sentence<br/><br/><br/><br/><br/><br/&g
t;<br/>
GO<br/><br/><br/><br/><br/><br/><br/
>
'<br/><br/><br/><br/><br/><br/><br/>

<br/><br/><br/><br/><br/><br/><br/>
Here the MS Documentation for GO Keyword:<br/><br/><br/><br/><br/><br/&g
t;<br/>
<snip><br/><br/><br/><br/><br/><b
r/><br/>
<br/>
SQL Server utilities interpret GO as a signal that<br/><br/><br/><br/><br/><br/><b
r/>
they should send the current batch of Transact-SQL<br/><br/><br/><br/><br/><b
r/><br/>
<br/>
statements to SQL Server. The current batch of<br/><br/><br/><br/><br/><br/><br/
>
statements is composed of all statements entered since<br/><br/><br/><br/><br/><br/><
br/>
the last GO, or since the start of the ad hoc session<br/><br/><br/><br/><br/><br/>
;<br/>
or script if this is the first GO<br/><br/><br/><br/><br/><br/><br/
>
</snip><br/><br/><br/><br/><br/><
br/<br/>
><br/>
<br/><br/><br/><br/><br/><br/><br/>
So one sentence become three, sentences one and three<br/><br/><br/><br/><br/><br/><
br/>
will fail, but sentence two (the one of our interest)<br/><br/><br/><br/><br/><br/&
gt;<br/>
will execute successfully.<br/><br/><br/><br/><br/><
br/<br/>
><br/>
<br/><br/><br/><br/><br/><br/><br/>
Hope you find this interesting<br/><br/><br/><br/><br/><br
/><br/>
<br/><br/><br/><br/><br/><br/><br/>
Cheers,<br/><br/><br/><br/><br/><br/>
;<br/>
-JC<br/><br/><br/><br/><br/><br/><br
/>
<br/><br/><br/><br/><br/><br/><br/>
_________________________________________________________<br/><
<br/>
<br/><br/>
<br/><br/><br/>
<br/><br/><br/><br/>
br/<br/><br/><br/><br/><br/>
><br/><br/><br/><br/><br/>
Do You Yahoo!?<br/><br/><br/><br/><br/><br/>
;<br/>
Información de Estados Unidos y América Latina, en Yahoo! Noticias.<br/><br/><br/><br/><br/><br/&
gt;<br/>
Visítanos en http://noticias.espanol.yahoo.com

[ reply ]