Date computation

SQLServerCentral Article

SQL Window Functions Series: LAG() and LEAD()

  • Article

Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.

5 (3)

You rated this post out of 5. Change rating

2023-12-11

5,085 reads

SQLServerCentral Article

Combine DATE and TIME to DATETIME2 in SQL Server

  • Article

The most common method on the internet for combining DATE and TIME columns in SQL Server is incorrect. This article demonstrates why that and other methods are incorrect and two lesser known high performance methods that produce correct results even for the "edge cases".

5 (4)

You rated this post out of 5. Change rating

2023-08-07

13,906 reads

SQLServerCentral Article

4.9 (10)

You rated this post out of 5. Change rating

2022-07-13

24,501 reads

Blogs

Copilot in Microsoft Fabric

By

Microsoft Copilot is an app that uses AI to help you find information, create content,...

Test Data Manager in Under 10 Minutes

By

Test Data Manager (TDM) is a suite of products from Redgate that make it...

T-SQL Tuesday #176 One piece of advice that you wish Past you had

By

This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...

Read the latest Blogs

Forums

Add custom toolbar to SSMS

By richardmgreen1

Hi all   I'm fairly certain I've done this before but can't figure it...

Add custom toolbar to SSMS

By richardmgreen1

Hi all   I'm fairly certain I've done this before but can't figure it...

Streaming Event Data through RabbitMQ to a Microsoft Fabric Eventstream

By Koen Verbeeck

Comments posted to this topic are about the item Streaming Event Data through RabbitMQ...

Visit the forum

Question of the Day

What's Wrong with this Table?

What's wrong with this code and causes an error?

CREATE TABLE Customer
(
    CustomerID INT NULL,
    FirstName NVARCHAR(50) NOT NULL,
    LastName NVARCHAR(50) NULL,
    Email NVARCHAR(100) NOT NULL,
CONSTRAINT CustomerPK PRIMARY KEY (CustomerID, LastName)
);


See possible answers