Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Генерация чисел в диапазоне в MS SQL
set nocount on; use rextester; if object_id('dbo.n','IF') is not null drop function dbo.n; go create function dbo.n(@ bigint,@f bigint)returns table as return with a as(select 0 c union all select 0), b as(select 0 c from a,a t), c as(select 0 c from b,b t), d as(select 0 c from c,c t), e as(select 0 c from d,d t), f as(select 0 c from e,e t), v as(select top(@f-@+1)0 c from f) select row_number()over(order by(select 0))+@-1 n from v; go select '050'+replace(str(min(n),7),' ','0'), '050'+replace(str(max(n),7),' ','0'), count(*) from dbo.n(0,9999999);
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Loan table
All the k-mers/n-grams
20181CSE0041
see a quell
text
Service broker
REGISTRO_ESTUDIANTES
Campeonato2DLuizFelipe
db_hotel29102020
Adding, subtracting, rounding and calculating differences
Please log in to post a comment.