SQL – g-blog

SQL Server Date to Varchar Conversion Formats

December 23, 2015February 9, 2018by pgurnigLeave a Comment

Often, I find the need for a specific format for a date. SQL has lots of great options with its convert function. Here's a handy chart. select convert(varchar, getdate(), 101) -- 12/23/2015 select convert(varchar, getdate(), 102) -- 2015.12.23 select convert(varchar, getdate(), 103) -- 23/12/2015 select convert(varchar, getdate(), 104) -- 23.12.2015 select convert(varchar, getdate(), 105) -- 23-12-2015 select [...]

Using a Correlated Subquery to Update a Base Table

December 19, 2015February 7, 2018by pgurnigLeave a Comment

The syntax for updating using correlated subqueries can be a little confusing at times. The example shown below uses a table variable as its target. The key is to include an aliased version of the table in the UPDATE's FROM clause. Once that is aliased, you can simply reference the alias in the subquery. For example: [...]