How to validate a query from Java.
843859Jan 25 2008 — edited Nov 20 2014Hello,
I want to check weather my query
(i.e. select * from table1 where field1 = 'abcd') is valid or not. (By asking database)
I mean it should check syntax as well as table names, fields, values etc.
& respond me in true or false (or OK or not).
I am using SQL Server 2005 (It is having this facility in SQL Server User Management Studio)
Thanks,
- Nachiket