Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH Sec(NUMBER) AS
- (
- SELECT 16000 AS NUMBER
- UNION ALL
- SELECT NUMBER + 1
- FROM Sec
- WHERE NUMBER < 16200
- )
- INSERT INTO TestTable
- SELECT NUMBER FROM Sec
- OPTION(MAXRECURSION 0)
- --select * from testtable
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement