The Basics of Using a Sequence as a Table Default

Question

The Basics of Using a Sequence as a Table Default

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
May 28, 2020 at 12:00 am

#3753463

Comments posted to this topic are about the item The Basics of Using a Sequence as a Table Default
May 31, 2020 at 3:35 pm

This was removed by the editor as SPAM
February 25, 2022 at 6:47 am

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

DaveBoltman SSC Veteran Points: 203 More actions · Answer 1

Aha! Great article, and I can immediately see a use case for having unique numbers even across different tables, where both tables get the number generated by the same sequence. e.g:

INSERT Table1 -- generates 1
INSERT Table1 -- generates 2

INSERT Table2 -- generates 3

INSERT Table1 -- generates 4
INSERT Table1 -- generates 5

INSERT Table2 -- generates 6
INSERT Table2 -- generates 7
INSERT Table2 -- generates 8

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 2

DaveBoltman wrote:

Aha! Great article, and I can immediately see a use case for having unique numbers even across different tables, where both tables get the number generated by the same sequence. e.g:
INSERT Table1 -- generates 1
INSERT Table1 -- generates 2

INSERT Table2 -- generates 3

INSERT Table1 -- generates 4
INSERT Table1 -- generates 5

INSERT Table2 -- generates 6
INSERT Table2 -- generates 7
INSERT Table2 -- generates 8

That a good demonstration but why would you need to do such a thing that wouldn't be a violation of good design? Not trying to start a fight here. I just can't think of a good reason to do such a thing.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 3

Steve, great article. Thanks for taking the time to write it up, work out the nice simple demo's and post it all. Well done!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 4

shamsmehra90 wrote:

i also want some details

Details on what? Don't expect folks to read every post on this thread to figure out what you're talking about. Be specific or quote the post you're identifying with! 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)