Search: [sql] - Shaarli

COALESCE vs. ISNULL T-SQL Functions | T-SQL content from SQL Server Pro

The COALESCE and ISNULL T-SQL functions are used to return the first nonnull expression among the input arguments. SQL Server practitioners often wonder what the difference is between the two functions.

http://sqlmag.com/t-sql/coalesce-vs-isnull

June 7, 2017 at 9:41:40 AM EDT *

sql mssql

FILLER

Tricky TSQL: NOT IN (NULL) > The MidnightDBA Star-Times

http://www.midnightdba.com/Jen/2016/08/tricky-tsql-not-in-null/

November 15, 2016 at 9:07:00 AM EST *

mssql sql

FILLER

Understanding SQL's Null

https://www.periscope.io/blog/understanding-sql-null.html

March 24, 2015 at 10:23:24 AM EDT *

sql

FILLER

SQL Workshop - Removing Duplicate Rows

http://i-programmer.info/programming/database/8296.html

February 25, 2015 at 2:35:11 PM EST *

sql

FILLER

14 SQL Server Indexing Questions You Were Too Shy To Ask

https://www.simple-talk.com/sql/performance/14-sql-server-indexing-questions-you-were-too-shy-to-ask/

April 11, 2014 at 11:50:56 AM EDT *

sql mssql

FILLER

Combining two columns from two tables and using sum

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/0a89cbcb-3a65-4007-99b2-1179c6834ea3/

November 26, 2012 at 3:43:43 PM EST *

sql

FILLER

Sun Java Article - Character Conversions from Browser to Database

http://java.sun.com/developer/technicalArticles/Intl/HTTPCharset/

February 9, 2011 at 2:18:51 PM EST *

sql unicode

FILLER

Coding Horror: A Visual Explanation of SQL Joins

http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html

December 17, 2010 at 10:21:43 AM EST *

sql

FILLER

Selecting points from a database by latitude/longitude within a bounding circle

http://www.movable-type.co.uk/scripts/latlong-db.html

December 10, 2010 at 1:29:18 PM EST *

sql

FILLER

SQL - fetch the row which has the Max value for a column - Stack Overflow

http://stackoverflow.com/questions/121387/sql-fetch-the-row-which-has-the-max-value-for-a-column

December 1, 2010 at 3:34:05 PM EST *

sql

FILLER

Technical Discussions: Identity Columns in DB2 AS/400

http://lk-tech.blogspot.com/2009/05/identity-columns-in-db2-as400.html

January 28, 2010 at 3:06:21 PM EST *

as400 sql ibm

FILLER

SQL Server FAQ - Truncating DATETIME Values to Dates without Time

http://dba.fyicenter.com/faq/sql_server/Truncating_DATETIME_Values_to_Dates_without_Time.html

November 20, 2009 at 10:30:53 AM EST *

sql mssql dates

FILLER

%postname%

http://lazytechie.com/top-84-mysql-performance-tips/

June 18, 2009 at 10:05:03 AM EDT *

mysql sql

FILLER

32 Tips To Speed Up Your MySQL Queries | AjaxLine

http://www.ajaxline.com/32-tips-to-speed-up-your-mysql-queries

February 4, 2009 at 10:42:43 AM EST *

sql performance

FILLER

Performance Tuning Best Practices for MySQL - good coders code, great reuse

http://www.catonmat.net/blog/performance-tuning-best-practices-for-mysql/

July 25, 2008 at 11:10:22 AM EDT *

mysql database performance sql

FILLER

How to select the first/least/max row per group in SQL at Xaprb

http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/

July 11, 2008 at 10:38:34 AM EDT *

sql tips

FILLER

perl.com: DBI is OK

http://www.perl.com/pub/a/2001/03/dbiokay.html

March 6, 2008 at 10:06:52 AM EST *

perl database dbi sql

FILLER

HOWTO Fully Install PostgreSQL on Debian - BeezNest

http://glasnost.beeznest.org/articles/218

October 5, 2007 at 10:25:57 AM EDT *

debian postgresql linux sql

FILLER

Cast and Convert in MSSQL

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp

July 26, 2007 at 11:22:17 AM EDT *

sql microsoft mssql

FILLER

MySQL ORDER BY With LIMIT and ANALYZE

http://hackmysql.com/case3

June 15, 2007 at 1:51:09 PM EDT *

sql mysql database optimization

FILLER