Sql Blogs & Blog Posts

Blogs on sql

Posting Frequency on sql


Distinct:

   Percent:


Latest Blog Posts on sql

  • The Weird Syntax of SQL DELETE From a JOIN by McBean Information Technology on May 22, 2009

    It is perfectly legal in most SQL dialects to DELETE records that come from a JOIN clause. However, I never remember the syntax because its kind of strange and I don't do it often.I wrote the following example in SQL Server 2005:delete from arledger...

  • Country / State / Province Lookup Tables for SQL server by Geospecialling on Feb 20, 2009

    Every time I build a contact form/database I hit this problem.  I need a set of tables for Country, State/Province lookup.  “But, that’s like 60 records and I don’t wanna type out every state and province!”. Every time, I hit the Go...

  • SQL Update with JOIN by McBean Information Technology on Dec 30, 2008

    I was trying to remember how to do an SQL UPDATE statement using fields from a JOIN. Its one of those things I don't do very often, and the syntax is not exactly intuitive. Its a good example of the power of SQL.The general template for such a statem...

Tags Related to sql