Tag Archives: code language
-
The STUFF function
17March 14, 2013 by Kenneth Fisher
While I was at the 2011 Pass Summit I was given the following piece of code to create a comma …
Continue reading -
Insert multiple values sets into a table in one command
8February 28, 2013 by Kenneth Fisher
The INSERT command has two distinct ways to load data into a table. And Both of these are very handy …
Continue reading -
DROP and CREATE vs ALTER
25February 25, 2013 by Kenneth Fisher
When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic …
Continue reading -
Something to watch out for when using sp_rename on Stored Procedures, Functions and Views
6February 11, 2013 by Kenneth Fisher
For those who don’t know, the stored procedure sp_rename allows you to change the name of a user-created object. Basically …
Continue reading -
EXECUTE, not required, but advisable.
1February 6, 2013 by Kenneth Fisher
The other day one of the developers I work with gave me a script similar to this: He was getting …
Continue reading -
Duplicate rows in a table
19February 4, 2013 by Kenneth Fisher
I recently got the following email: “I just keyed in two rows into a table with all identical column values. …
Continue reading -
Small changes, big effects
Leave a commentJanuary 30, 2013 by Kenneth Fisher
We got a call last week about an application that was running slowly. The server was showing about 80% CPU …
Continue reading -
IsMSShipped
3January 23, 2013 by Kenneth Fisher
I just wanted to do a brief highlight of a handy little object property. For those of you who aren’t …
Continue reading -
My view isn’t reflecting changes I’ve made to the underlying tables.
8January 20, 2013 by Kenneth Fisher
Problem: You’ve added columns to the base table of one of your views, but the view isn’t reflecting the change. …
Continue reading
SQL Studies 