Category Archives: T-SQL
-
To the page and back again
1January 18, 2016 by Kenneth Fisher
To the page It’s not one of those things you have to do frequently but every now and again you …
Continue reading -
What is RESULT SETS?
11January 14, 2016 by Kenneth Fisher
I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before …
Continue reading -
What does that N in nvarchar really mean?
9December 28, 2015 by Kenneth Fisher
In any study of Data Types in SQL Server you are going to have to look at the various string …
Continue reading -
What is the current database context?
3December 21, 2015 by Kenneth Fisher
Every now and again it can be very helpful to know what the current database context is when you are …
Continue reading -
Generating scripts for previous versions of SQL
1October 21, 2015 by Kenneth Fisher
I make a habit of using the latest version of SSMS even if I’m not working with the latest version …
Continue reading -
Working with “special” names
4October 19, 2015 by Kenneth Fisher
What do you do when you need to use a special character in a name? Well, I guess I should …
Continue reading -
Updating a view
2September 30, 2015 by Kenneth Fisher
I was recently asked how to update views. Specifically the question was about using triggers to update a view. So …
Continue reading -
“sql_handle” is not a recognized table hints option.
Leave a commentSeptember 23, 2015 by Kenneth Fisher
I’ve you’ve run a query similar to the following: And gotten an error similar to: Msg 321, Level 15, State …
Continue reading -
Using @@ROWCOUNT can be a bit tricky
2September 16, 2015 by Kenneth Fisher
@@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently …
Continue reading
