/*
Author: Michael Thomas 
email: michael@michael-thomas.com

Used for the examples at: www.michael-thomas.com for MSSQL Commands.
Section:  Global Variables.

*/
use master
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'MyTempDB') begin
  DROP DATABASE [MyTempDB]
end
go

create database MyTempDB

use MyTempDB

-- **************************
-- MyTable
-- **************************

if exists (select * from [dbo].[sysobjects] where id = object_id(N'MyTable') ) begin
  drop table MyTable
end
go

create table MyTable ( myInt int, myChar char(1), myNVarchar nvarchar(255) )

insert into MyTable ( myInt, myChar, myNVarchar ) values (1, 'A', 'Hello World 1')
insert into MyTable ( myInt, myChar, myNVarchar ) values (2, 'B', 'Hello World 2')
insert into MyTable ( myInt, myChar, myNVarchar ) values (3, 'C', 'Hello World 3')

-- **************************
-- MyTableRowCount
-- **************************

if exists (select * from [dbo].[sysobjects] where id = object_id(N'MyTableRowCount') ) begin
  drop table MyTableRowCount
end
go

create table MyTableRowCount ( myInt int, myChar char(1), myNVarchar nvarchar(255) )

insert into MyTableRowCount ( myInt, myChar, myNVarchar ) values (1, 'A', 'Hello World 1')
insert into MyTableRowCount ( myInt, myChar, myNVarchar ) values (2, 'B', 'Hello World 2')
insert into MyTableRowCount ( myInt, myChar, myNVarchar ) values (3, 'C', 'Hello World 3')

-- **************************
-- MyTableRowGlobalVarError
-- **************************

if exists (select * from [dbo].[sysobjects] where id = object_id(N'MyTableGlobalVarError') ) begin
  drop table MyTableGlobalVarError
end
go

create table MyTableGlobalVarError ( myIntNotNull int not null, myNVarchar nvarchar(255) )

insert into MyTableGlobalVarError ( myIntNotNull, myNVarchar ) values (1, 'Hello World 1')
insert into MyTableGlobalVarError ( myIntNotNull, myNVarchar ) values (2, 'Hello World 2')
insert into MyTableGlobalVarError ( myIntNotNull, myNVarchar ) values (3, 'Hello World 3')