Tag Archives: code language
-
More than sp_help
6August 14, 2014 by Kenneth Fisher
If you have worked with SQL Server for very long you have probably run across the extremely useful system function …
Continue reading -
SchemaBinding – What & Why
29August 6, 2014 by Kenneth Fisher
What When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying …
Continue reading -
What is ANSI_NULLS and why will I be glad when it finally goes away?
13July 28, 2014 by Kenneth Fisher
Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and …
Continue reading -
Why am I getting a primary/unique key violation?
3July 23, 2014 by Kenneth Fisher
This may seem like a question with a simple answer but there is a bit more to it than you …
Continue reading -
Yes, Virginia, you can have too much white space.
22July 16, 2014 by Kenneth Fisher
When I was in college and taking programming classes (back in the days when “a T-Rex ate my 5.25 inch …
Continue reading -
What does it mean that a value is NULL?
11July 14, 2014 by Kenneth Fisher
Let’s start by assuming that ANSI_NULLS are ON. If you aren’t sure what ANSI_NULLS are exactly, don’t worry, I’ll be …
Continue reading -
Dealing with a long string
4June 25, 2014 by Kenneth Fisher
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the …
Continue reading -
15 years of experience with Identity columns
51June 4, 2014 by Kenneth Fisher
An identity column is an auto incrementing column An identity column is typically used as a primary key A primary …
Continue reading
SQL Studies 