Help with SQL :)

by Abel R
My article is called Easing into SQL and it talks about how tedious writing code can be. The article mentions common mistakes such as logic errors and typos and it also mentions how you can create most basic statements in the query design grid using Microsoft Access. When using Access you can produce an equivalent SQL statement for every query, and you can use this to your advantage. You can click the View button and choose SQL View and Access will display the query’s equivalent SQL statement. This can be very useful if you;re having trouble with SQL statements and don’t feel like producing it from scratch.

I think this article is relevant to our project 3 because as we have to produce more and more complex SQL statements as we may run into trouble and by using this method using Access, we can get an idea of how the statement is supposed to be. The SQL statement may not be perfect but with some adjustments we can produce the correct one.

 

Citation

Harkins, S. S. (2001, March 20). Easing into sql. Retrieved from http://www.pcmag.com/article2/0,2817,34162,00.asp

 

2 thoughts on “Help with SQL :)”

  1. This is a great article regarding SQL statements. Any help we can get in making it simpler to write code is always welcome in my opinon.

  2. I agree with gerardgonzales. SQL is so new to most of us, that any tidbits of information goes a long way for us students. Especially me!

Comments are closed.