Stats: 3,188,997 members, 7,936,194 topics. Date: Saturday, 31 August 2024 at 07:31 AM |
Nairaland Forum / Science/Technology / Webmasters / Sql Code Analyzer (831 Views)
Meta Tag Analyzer - Free / Attention adword analyzer users / Creating Complex / Advanced Search Forms With Sql Queries In Dreamweaver (2) (3) (4)
(1) (Reply)
Sql Code Analyzer by juintade(m): 12:07pm On Oct 31, 2007 |
Hello, Just wondering if any body knows an Integrated Development Environment (IDE) that I could use to analyse the SQL code which I have written. I am having syntax error, but I have spent hours on it going through each line of the code but to no avail. I am sure there must a software/IDE used by advance SQL statement developers. Many thanks in advance Note: the SQL statement consist of the IN, SELECT, UNION, INNFER JOIN keywords and it is used to query an Acess Database |
Re: Sql Code Analyzer by my2cents(m): 1:52pm On Oct 31, 2007 |
I haven't used SQL Server or Access in a looong time but I would expect them to have some sort of a design window which will enable you to validate your queries. Be that as it may, what I typically do, if this is a web app, is print out the actual query with the values being sent on my pages for verification. Try this. Also, post the query here. One thing I have learnt in DB design is it pays to design your DBs and queries without a computer. Once it makes sense, you then port it into your RDBMS. Keep us posted. |
Re: Sql Code Analyzer by juintade(m): 2:18pm On Oct 31, 2007 |
I found a product in the form of Oracle SQL Developer. Dont know what it does but I am about to give it a shot Many thanks my2cents, I shall keep you posted. |
(1) (Reply)
Check Out The Nairaland Magazine / Please Webmasters I Need Help Here / Webmaster Certification & Get 1 Year Bsc(hons) In Computing In Uk
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 7 |