php script sql query parser sql2tree

http://www.phpclasses.org/browse/package/4916.html
Build a tree to represent an SQL query !
Video of a php class that can be used to build a tree to represent an SQL query.
It takes a given SQL query and parse it to extract the structure or queries and sub-queries. The resulting structure is returned as an array.
Currently it supports only SELECT, INSERT, [...]

SQL Server 2008 and using Transact SQL (TSQL)

http://www.learningsqlserver2008.com/
If you want to be good at working with databases, strong knowledge of TSQL is a must. In this important video, we start off with a little background and the database we will use AdventureWorks2008. We start off with the SELECT statement which is used to return data. The basic syntax is discuss with an [...]

Microsoft Access Update Query

How to create an UPDATE QUERY in Microsoft Access. Go to www.599CD.com/Access/YouTube for more free tutorials.
Duration : 0:5:0