SQL Server Numbers table

- 
if not exists (select 1 from information_schema.schemata where schema_name = 'util')
begin
    exec sp_executesql N'create schema [util];';
end;
go
 
create table util.Numbers (
    Num int not null
    ,constraint PK_util_Numbers primary key (Num)
);
go
 
declare @MaxValue int = 1000000;
while (select count(1) from util.Numbers) < @MaxValue
begin
    declare @n int = @MaxValue - (select count(1) from util.Numbers);
    declare @offset int = isnull((select max(Num) from util.Numbers), 0);
    insert util.Numbers
    select top (@n) row_number() over (order by o1.[object_id]) + @offset
    from sys.objects o1
    cross join sys.objects o2
end;
 
select * from util.Numbers order by Num;
go

Comments

Post a Comment

Popular posts from this blog

Left Join in Entity Framework

-
Image
If you need a left join in Entity Framework, you have a couple options. First, if you’re using a real foreign key that just happens to be nullable, then you can use the regular navigation properties. But if you’re doing a left join manually, or with other factors, then you need to do things just a little differently: Suppose we have the following database: create table dbo . Foods ( FoodID int not null identity primary key , FoodName varchar ( 100 ) not null ) ; go insert dbo . Foods ( FoodName ) values ( 'Pizza' ) , ( 'Chicken' ) , ( 'Potatoes' ) , ( 'Broccoli' ) ; go create table dbo . People ( PersonID int not null identity primary key , FirstName varchar ( 100 ) not null , FavoriteFoodID int null , constraint FK_Person_FavoriteFoodID foreign key ( FavoriteFoodID ) references dbo . Foods ( FoodID ) ) ; go insert dbo . People ( FirstName , FavoriteFoodID ) values ( 'John' , 1 ) ,
Read more

C# Record Serialization

-
Image
With .NET 5, you get a new concept called record . Lots of cool things, one of which is that you can serialize and deserialize with JSON just like a class, except you don't need to define properties one at a time, or even the body of the type. Apparently XML serialization doesn't quite work, so stick with JSON. View code on GitHub
Read more

Mustache with JavaScript in Browser

-
Image
Mustache is a nice and simple templating engine that can be used just about anywhere. It's not as powerful as others like Handlebars, but its simplicity means there's less to screw up. Learn more about Mustache Learn more about Mustache.js View code on GitHub
Read more