WUT?

Remember this if you want to use sp_

Erik Darling, of Erik Darling Data (blog | Twitter) recently posted a very interesting video (my YouTube playlist is all Erik Darling Data videos and Honest Trailers). In this video he demonstrates an easily repeatable issue about naming weirdness and the CREATE OR ALTER PROCEDURE syntax, with stored procedures starting with sp_. The video is
-> Continue reading Remember this if you want to use sp_

Post image

Testing for Object Existence: CREATE OR ALTER

For the longest time, T-SQL writers have had to wrestle with ways of testing for an object’s existence so that it can either be dropped and recreated, or modified as needed. Last week we covered the new DROP … IF EXISTS syntax. This week goes into how we handle changes to objects. We’ve spent many
-> Continue reading Testing for Object Existence: CREATE OR ALTER