The SQL Server 2008 Datetimeoffset Data Type
The Datetimeoffset Data Type was introduced in SQL Server 2008 (and .Net Frameword 3.5) and is the most advanced date and time date type available.
2014-03-28 (first published: 2011-04-18)
14,571 reads
James Skipwith
Custom Sequence Numbering
This article shows how to implement low cost custom sequence numbering logic via a cunning use of the the ROW_NUMBER() function
2013-06-14 (first published: 2011-02-07)
18,904 reads
Automatically Generate Stored Procedures
This article will show you how to automatically generate insert, update, and delete procedures for tables in your database
2013-01-01 (first published: 2011-02-10)
24,235 reads
Blogs
More Azure Blob Storage enhancements
By James-Serra
I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob...
Daily Coping 25 May 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
A Byte of Redgate–Bonus Queso Recipe
By Steve Jones
As part of the Community Circle effort at Redgate, we’ve released a cookbook: A...
Forums
HTML Mail with more than one line in Resultset
Hello all, i would like to send a html Mail with sql server. But...
AS Tabular and Sample Data in VS
Hello all, I really need your help – I want to use the sample...
SSIS Export Flat File as Fixed Width
Hi Forum, I have a table that uses the script below to create fields...
Ask SSC