YouTube on MSN

Learn SQL basics in just 15 minutes!

Learn SQL basics in just 15 minutes with this tutorial focused on using SQL with MySQL. Topics covered include: - What SQL is ...
Ars Technica

"Old Style" SQL Joins using the WHERE clause

SELECT a.au_id, t.title FROM titles t, authors a, titleauthor ta WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id AND t.title LIKE '%Computer%' SELECT a.au_id, t ...
Ars Technica

T-SQL Using a @variable in WHERE IN ( @varname )

I haven't really done anything with dynamic SQL yet. However, it looks like you are just declaring a string and tossing your SQL into it. Then using executing the stored procedure sp_executesql (which ...