Skip to content

Instantly share code, notes, and snippets.

View Jorriss's full-sized avatar

Richie Rump Jorriss

View GitHub Profile
@Jorriss
Jorriss / install.sql
Last active December 14, 2015 16:19 — forked from DamianEdwards/install.sql
Changed the RAISERROR flags to %d. The parameters that are being passed are of type integer. Per BOL the proper flag for a integer parameter is %d. http://msdn.microsoft.com/en-us/library/ms178592.aspx
DECLARE @SCHEMA_NAME nvarchar(32),
@SCHEMA_ID int,
@SCHEMA_TABLE_NAME nvarchar(100),
@TARGET_SCHEMA_VERSION int,
@CREATE_MESSAGE_TABLE_DML nvarchar(1000),
@MESSAGE_TABLE_NAME nvarchar(100),
@MESSAGE_TABLE_COUNT int;
SET @SCHEMA_NAME = 'SignalR'; -- replaced from C#
SET @SCHEMA_TABLE_NAME = 'Schema'; -- replaced from C#
DECLARE @SCHEMA_NAME nvarchar(32),
@SCHEMA_ID int,
@SCHEMA_TABLE_NAME nvarchar(100),
@TARGET_SCHEMA_VERSION int,
@CREATE_MESSAGE_TABLE_DML nvarchar(1000),
@MESSAGE_TABLE_NAME nvarchar(100),
@MESSAGE_TABLE_COUNT int;
SET @SCHEMA_NAME = 'SignalR'; -- replaced from C#
SET @SCHEMA_TABLE_NAME = 'Schema'; -- replaced from C#