Mattias Karlsson devlead

One of the maintainers of the @cake-build projects. Partner & Technical Fellow @WCOMAB

devlead / multi-insert.sql

Last active August 29, 2015 14:20 — forked from damianh/multi-insert.sql

+DROP TABLE dbo.Events
+DROP TABLE dbo.Streams
+CREATE TABLE dbo.Streams(
+	StreamId CHAR(40) NOT NULL,
+	StreamIdOriginal NVARCHAR(1000) NOT NULL,
+	StreamIdInternal INT IDENTITY(1,1) NOT NULL,
+	IsDeleted BIT NOT NULL DEFAULT ((0)),
+	CONSTRAINT PK_Streams PRIMARY KEY CLUSTERED (StreamIdInternal)
+);