SQL, too, maintains this distinction and does not confuse data as if it were commands. Most programs that work with databases, however, are not written in SQL directly.

In most implementations of SQL, you pull information from two tables by using a SELECT command in this form: SELECT table1.column1, table1.column2, table2.column1, table2.column2 ...

Making Your T-SQL Work Smarter: sp_MSforeachdb. Last time, we showed how to take advantage of a built-in stored to run a command against multiple tables.