What do I use to code in SQL?

[appletonsally]

I have been reading up on SQL and it seems to be a really intuitive language but, what do you actually use to code it. For example, to code in visual basic you can use visual basic applications in Microsoft Excel or you can buy a visual basic studio. What are the equivalents for SQL?

 

[cmmrfrds]

A helpful sql interface is query analyzer that comes with SQL Server. The executable is called either isql.exe or isqlw.exe. You put your code in the top frame and can see the results immediately in the bottom frame.

 

[rac2]

A SQL processor works with a relational database. You need a relational database system to use SQL. You can buy MS Access, your company can buy MS SQL Server, or Oracle. You can obtain a free limited-use copy of Oracle from Oracle either on CD or download. All three have SQL processors and tools for writing and executing SQL statements. You can write SQL statements in any text-editor, but that won't be much fun without a SQL processor to tell you what you did wrong and to submit your statements to a database.