We will write very simple query. Do not worry about how will I write without loop.
Query
- ; with CTE as
- (
- select 1 Number
- union all
- select Number +1 from CTE where Number<100
- )
- select *from CTE
Output
Write A Query To Print 1 To 100 In SQL Server Using Without Loop
Join the conversation! Your thoughts help the community grow.