data types | SQL Studies

Skip to navigation
Skip to main content
Skip to secondary content
Skip to footer

Tag Archives: data types

Using LEN wrong.
4
June 2, 2016 by Kenneth Fisher

I was reading someone’s question the other day on StackExchange and while the existing comments/questions solved the OP’s (original poster) …
Continue reading

Category: Microsoft SQL Server, Query Plans, SQLServerPedia Syndication, T-SQL | Tags: data types, microsoft sql server, T-SQL
varchar(1) VS char(1)
3
February 15, 2016 by Kenneth Fisher

The other day I made a somewhat flip coment on twitter. (I know, everyone is shocked right?) varchar(1) Really? It’s …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: data types, microsoft sql server, T-SQL
How are COALESCE and ISNULL different?
6
August 7, 2013 by Kenneth Fisher

At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2) …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: COALESCE, code language, data types, isnull, language sql, microsoft sql server, T-SQL

ToadWorld Pro of the Month November 2013