SQL checking
This is a multi-part message in MIME format.
------=_NextPart_000_0147_01BF068D.7E61FE90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
1.. Is there any function or command available, so as to check whether =
a SQL statement is syntactically correct without actually executing it.
2.. If such a function exists, can it be used to check column related =
issues as well?=20
For e.g.. without executing the SQL below I want to check its syntax, =
and also return an error if column1 is defined as INT, or column2 is of =
length 40.
select column1 from table where column1 =3D 'ABC' and column2[40,41] =3D =0
------=_NextPart_000_0147_01BF068D.7E61FE90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<OL>
<LI><FONT face=3DArial size=3D2>Is there any function or command =
available, so as=20
to check whether a SQL statement is syntactically correct without =
actually=20
executing it.</FONT></LI>
<LI><FONT face=3DArial size=3D2>If such a function exists, can it be =
used to check=20
column related issues as well? </FONT></LI></OL>
<DIV><FONT face=3DArial size=3D2>For e.g.. without executing the SQL =
below I want to=20
check its syntax, and also return an error if column1 is defined as INT, =
or=20
column2 is of length 40.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>select column1 from table where column1 =
=3D 'ABC' and=20
column2[40,41] =3D 0</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV></BODY></HTML>
------=_NextPart_000_0147_01BF068D.7E61FE90--