sequence_azure.sql

-- Creates a sequence table that is compatible with SQL Azure, at the cost of wasting space in the PK. Not that that really matters very much in Azure.
if object_id('dbo.sequence') is null
begin
	create table dbo.sequence
	(
		n smallint not null,
		constraint PK_sequence
			primary key clustered (n)
	)
end
GO
if (select count(*) from dbo.sequence) < 65536
begin
	truncate table dbo.sequence;

	with
	n1 (n)
	as
	(
		select 0
		union all
		select 0
	),
	n2 (n)
	as
	(
		select 0
		from n1 a, n1 b
	),
	n4 (n)
	as
	(
		select 0
		from n2 a, n2 b
	),
	n8 (n)
	as
	(
		select 0
		from n4 a, n4 b
	),
	n16 (n)
	as
	(
		select 0
		from n8 a, n8 b
	)
	insert dbo.sequence (n)
	select (row_number() over (order by n)) - 1 - 32768
	from n16
end
GO