How to write a procedure to print numbers from 1 to 100?

Last Post

RSS

Posts: 18

Topic starter

Jul 27, 2020 11:22 am

(@vinodkrsetty5895)

Active Member

Joined: 4 years ago

Can anyone help me?

I want to write a procedure to print numbers from 1 to 100. How can I achieve this?

Topic Tags

proceduretoprintnumber

1 Reply

Posts: 47

Lavanya

Guest

Jul 28, 2020 6:41 am

(@Lavanya)

Eminent Member

Joined: 4 years ago

You can use the below query to print numbers from 1 to 100

Declare @ Start Int
Declare @ End Int

Set @Start =1
Set @End =100

While @Start<=@End

Begin

Pring @start

Set @Start = @Start+1
End