• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Preparing SQL Statements

SQL is to databases as HTML is to Web pages. SQL is an amazingly versatile language, as much at home in Microsoft Access as it is in SQL Server or Oracle data sources. SQL can manage records (updating, adding, or deleting), gather subsets, or create tables and even other SQL statements on the fly.

As pointed out in the beginning of this chapter, you don’t have to know SQL to build basic applications in Dreamweaver. The key word here is basic; when you start to need more than simple recordsets filtered on one field or derived from a single table—and that time will come sooner than later—you’ll need to write some SQL. Although advanced SQL statements can become involved and difficult to decipher, the language is quite approachable.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint