In this workbench, Robyn Page provides a gentle introduction to the use of dates in SQL Server. In this new version of her article, it is brought up to date with the newer Datetime features in SQL Server 2005 and 2008.
2010-05-27
5,598 reads
Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.
2010-04-07
35,877 reads
Learn how to get most of the formats required by different countries and applications, using one common date function.
2009-06-02
3,748 reads
This short tip shows how you can convert an integer date, such as those stored in msdb to a real datetime value.
2009-04-03
3,612 reads
Brandon Galderisi brings us a new article that looks at how a table of dates can be useful in a SQL Server application.
2008-12-17
12,478 reads
Learn how data is stored within DATETIME and SMALLDATETIME and get an overview of the TIMESTAMP data type -- as it's often confused with these two primary date/time data types.
2008-08-15
6,427 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers