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

Description:  Insert examples.

*/

-- **************************************
-- Create DB: MyTempDB_Databases_A
-- **************************************

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

create database [MyTempDB_Databases_A]
go

use MyTempDB_Databases_A

-- **************************
-- Create TABLE: MyTempDB_Databases_A - MyTable_A
-- **************************

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

create table MyTable_Inserts( 
  id int IDENTITY(1,1) not null,
  myInt int, 
  myChar char(1), 
  myNVarchar nvarchar(255) 
)

-- Ex: Standard insert
insert into MyTable_Inserts ( myInt, myChar, myNVarchar ) values (1, 'A', 'Hello World 1')
insert into MyTable_Inserts ( myInt, myChar, myNVarchar ) values (2, 'B', 'Hello World 2')
insert into MyTable_Inserts ( myInt, myChar, myNVarchar ) values (3, 'C', 'Hello World 3')

-- Insert from a select & union statement
insert into MyTable_Inserts ( myInt, myChar, myNVarchar ) 
  select 4, 'D', 'Hello World 4'
  union all
  select 5, 'E', 'Hello World 5'
  union all
  select 6, 'F', 'Hello World 6'

-- Insert from a select from a table.
insert into MyTable_Inserts ( myInt, myChar, myNVarchar )
  select (100+myInt) as 'myInt', myChar, myNVarchar from MyTable_Inserts

select * from MyTable_Inserts