Sunday, December 03, 2006

Top SQL Server Google Searches For November 2006

These are the top SQL Searches on this site for the month of November. this time I left some of the searches that have nothing to do with SQL Server or programming (Like breeds of cats that produce less FEL D1s)

Here is the list:
apprentice sample narrative report in bank
generate table script
breeds of cats that produce less FEL D1
CSV import MS SQL ASP
gravelines
case in sql server 2005
if condition in sql server 2005
search string in a string sql server
sql 2000 olap range
TOP DOWNLOAD SOFTWARE
169.254.x.x
DATE CONVERSIONS
sp_send_dbmail

As you can see if and case are frequent searches. Just yesterday I answered a case question; the poster had this code

set t7 =
case
when (t4 is null and t5 is null) then cast(0 as varchar)
when t4 is null then cast(t5 as varchar) else cast(t4 as varchar)
end


Which of course can be replaced with

set t7 =coalesce(t4,t5,0)

This will return the first non non value, since t7 is a varchar column there is no reason to convert to varchar either

No comments: