sql code readability

Posted by Michael Buen on April 24, 2008

though logically the same, this is easier to read: select coalesce( (select CURRENT_TIMESTAMP unlocked_expiration from invoice where invoice_rec_id = 'value here'), true) as has_expiredthan this: select coalesce( (select unlocked_expiration ... [read more]

Rating

not rated
Login to rate this.

Reviews

Submit a comment / review

There are currently no comments or reviews.

Related

  • LINQ to SQL LINQ to SQL LINQ to SQL is a component of .NET Framework version 3.5 that provides a run-time infr...
    By default on August 21, 2011
  • Microsoft SQL Server Sustained Engineering group is pleased to announce the release of SQL Server 2008 Service Pack 3. Both the Service Pack and ...
    By SQLServerTeam on October 7, 2011
  • There appears to be various different recommendations of ways for updating a term store field value and I’d like to chip in with mine. Some reco...
    By Stuart Roberts on November 20, 2010
  • In one of my current projects I have some pivot reports that show count of issues in different states. Grouping depends on report. States are dynamic ...
    By Gunnar Peipman on January 2, 2012
  • How to set SharePoint blog comments permission If you want to allow your SharePoint blog visitors to comment on blog posts you need to explicitly...
    By zakir hossain on March 31, 2011
  • Hi All, Ari Ijäs shared a nice post includes a simple steps to configure Search Services Application in SharePoint Server 2010 to crawling for anony...
    By Mohamed Abdel Ghaffar on April 16, 2011
  • Reason : Some time data pumb jobs marked as orphaned (stopped abnormally) and job information still remain in database. On starting datapump job star...
    By Blogger on August 17, 2010
  • Today i learned one new thing in sql server -SQL server Flight RecorderHow to enable sql server blackbox traceDECLARE @traceid INT;EXEC sp_trace_creat...
    By kuraliniyan s on December 23, 2009
  • Supporting successful services on the web means scaling your back-end databases across multiple dimensions. This blog focuses on scaling access method...
    By Oracle's MySQL Blog on August 5, 2011

Submit a review:

Login required.