TSQL Circle Live

Blog Post

What is an Identity?

        Identity (or AutoNumber) is a column that automatically generates numeric values.         A start and increment value can be set, but...

2016-01-26

123 reads

Blogs

SQL Blunders: Stop Writing These Pointless Queries & Write Smarter!

By

They run, they return data. So what? Some SQL queries just waste your time...

Copilot Outside of SSMS Seems to Work

By

I read Brent’s first look at SSMS and Copilot in there. He didn’t have...

A New Word: Falesia

By

falesia– n.  the disquieting awareness that someone’s importance to you and your importance to...

Read the latest Blogs

Forums

Helping Students with a Data Professional Career

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Helping Students with a Data...

Calculating Month End

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Calculating Month End

Parameterize Connections in Microsoft Fabric Data Factory using Variable Libraries

By Koen Verbeeck

Comments posted to this topic are about the item Parameterize Connections in Microsoft Fabric...

Visit the forum

Question of the Day

Calculating Month End

I want to calculate the end of the previous month as a date that I can use in running a report. What is the best way to do this in SQL Server 2022, assuming I have a date stored in @d?

See possible answers