Tag Archives: SQLNewBlogger

Quick Scalar Tables–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This actually comes from Itzik Ben-Gan, by way of Kevin Feasel.  Kevin’s post is about CROSS APPLY, which is … Continue reading

Posted in Blog | Tagged , , | Comments Off on Quick Scalar Tables–#SQLNewBlogger

Rename a Primary Key–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Having system named objects is one of those things that people may debate, but as you move to more … Continue reading

Posted in Blog | Tagged , , | Comments Off on Rename a Primary Key–#SQLNewBlogger

Getting Table Change Scripts–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the really basic things I think everyone should understand is how to get scripts from Management Studio … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Getting Table Change Scripts–#SQLNewBlogger

Using sp_executesql Parameters –#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I haven’t used sp_executesql much. Instead, my habitually way of executing dynamic SQL has been with EXEC(). There are … Continue reading

Posted in Blog | Tagged , , | Comments Off on Using sp_executesql Parameters –#SQLNewBlogger