Check if bigint limit is reached

Question

0.00/5 (No votes)

See more:

I am developing a WebApp using ASP.net C#.
I am trying to generate the primary key in the table in this format ID-45000-200 (VARCHAR(900))

It increments in this format
ID-1-1
ID-1-2
ID-1-3
ID-2-1

I am trying to develop a SQL UDF for generating this ID value.
The number part is BigInt so I want to know if there is any way to check if the positive BigInt Max value limit is reached in SQL SERVER 2012.

What I have tried:

I have tried hardcoding the min & max values in variables & checking against that, But that seems dumb. I want to know if there is a cleaner way of doing that in SQL Server 2012.

Posted 28-Jun-18 4:59am

Christopher Fernandes

Updated 28-Jun-18 5:10am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2018-06-28T05:11:00

Solution 1

Why check, bigint is 2^63 ?

Even if you create 10000 every second you wouldn't reach the limit in 29 million years!

Posted 28-Jun-18 5:11am

Mehdi Gholam

Comments

Christopher Fernandes 28-Jun-18 23:24pm

I know BigInt is 2^63. But by my estimates, The app will be generating 250,000 ID every day.
As you can see there are 3 parts to the ID value a)ID b) bigint middle number c) bigint outer number
So whenever outer number reaches the upper limit of bigint I want it to increment the middle number by one and set outer number to one again.

Mehdi Gholam 28-Jun-18 23:47pm

10000 (/s) * 3600 (s/h) * 24 (h/day) = 864,000,000 /day