Write a TSQL query which returns sum of 1-100

Question

Hi,

Kindly help me on t tsql code how to get sum of 1-100?

Answer 1

Hi @Nandan Hegde
Please also check this script using while loop:

DECLARE @i INT,@sum INT  
SET @i=1  
SET @sum=0  
WHILE @i<=100  
 BEGIN  
   SET @sum=@sum+@i  
   SET @i=@i+1  
 END  
SELECT @sum  

Best regards,
LiHong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hey,
There is a formula for sum of first n numbers :
N *(N+1) /2

So you can write in sql:

Select 100*101/2

Answer 3

Nandan is right on the money that you can use that formula. But else you need a table of numbers, which I have written about here: https://www.sommarskog.se/Short%20Stories/table-of-numbers.html.