Tag Archives: T-SQL

Output into a Table–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I often see people struggling to use triggers for auditing, or having issues with building them to handle multi … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Rounding Challenges–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Rounding is an interesting activity, and one that I think people sometimes don’t pay enough attention to. Recently I … Continue reading

Posted in Blog | Tagged , , | 4 Comments

Dropping Masking from a Column–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a quick one. As I experimented with Dynamic Data Masking for the Stairway to Dynamic Data Masking, … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

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 , , | Leave a comment

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 , , | Leave a comment

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 , , , | Leave a comment

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 , , | Leave a comment

Basic XML Node Query–#SQLNewBlogger

  Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a question recently about querying an XML document. Certainly avoid this in the database if you … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Getting the Previous Row Value before SQL Server 2012

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across a post where someone that was trying to access the previous value in a table for … Continue reading

Posted in Blog | Tagged , | Leave a comment

LAST_VALUE–The Basics of Framing

I did some work a 3-4 years ago, learning about the Windowing functions and enjoying them so much I built a few presentations on them. In learning about them, and trying to understand them, I found some challenges, and it … Continue reading

Posted in Blog | Tagged , | Leave a comment