When programming stored procedures, functions, or just writing queries for Microsoft SQL Server databases, we often need date variables set to the beginning or end of a day, week, month or year. This is commonly done by concatenating strings – such as: DECLARE @InputDate DATETIME SET @InputDate = ‘4/1/2004 ‘ + ’00:00:00’ That works but… [Read More]
