raleighkozey

Have you ever wondered what it would be like to have a random chat with someone halfway across the globe? Or maybe you’re just looking for an easy way to pass the time and meet new people while sipping on your favorite coffee? If any of that sounds like you, let me introduce you to Omegle—a platform that has mastered the art of bringing strangers together on a virtual stage.

All authors

It seems we can’t find what you’re looking for. Perhaps searching can help.

Blogs

Save Azure PostgreSQL Backup to Storage

By

This may or may not be helpful in the long term, but since I’m...

The Book of Redgate: What’s Great about Redgate?

By

“I’m sick of hearing about Red Gate.” The first article in the book has...

SQL Server Performance – What IT Leaders Need to Know

By

IT leaders have a lot on their plates! Budgets, staffing, security, uptime, and keeping...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Widespread New Technology Adoption

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Widespread New Technology Adoption

Multiple Sequences

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Sequences

Visit the forum

Question of the Day

Multiple Sequences

In SQL Server 2022, I run this code: 

CREATE SEQUENCE myseqtest START WITH 1 INCREMENT BY 1;
GO
CREATE TABLE NewMonthSales
  (SaleID    INT
  , SecondID int
 , saleyear  INT
 , salemonth TINYINT
 , currSales NUMERIC(10, 2));
GO
INSERT dbo.NewMonthSales
  (SaleID, SecondID, saleyear, salemonth, currSales)
SELECT
  NEXT VALUE FOR myseqtest
, NEXT VALUE FOR myseqtest
, ms.saleyear
, ms.salemonth
, ms.currMonthSales
FROM dbo.MonthSales AS ms;
GO
SELECT * FROM dbo.NewMonthSales AS nms
Assume the dbo.MonthSales table exists. If I run this, what happens?

See possible answers