use master
go
Create Database myNewDatabase
go

use myNewDatabase
go
---------------------------------------------------------
--create a table (CREATE TABLE in Books Online)
if object_id('myNewTable1') > 0
	drop table myNewTable1
go

create table myNewTable1
	(myNewTable1ID	int identity(1,1) primary key
	,i int not null
	,createDate datetime not null
	,updateDate datetime null)
go

----------------------------------------------------------
--create a storte procedure to insert data to myNewTable1 (CREATE PROCEDURE in Books Online)
if object_id('myNewTable1_ins') > 0
	drop procedure myNewTable1_ins
go

create procedure mynewTable1_ins
@i int
as

insert myNewTable1 (i, createDate)
values (@i, getdate())

go
----------------------------------------------------------

exec myNewTable1_ins @i = 10
exec myNewTable1_ins @i = -2

select myNewTable1ID
	,i
	,createDate
	,updateDate
from	myNewTable1

go

use master
drop database myNewDatabase