-- if table exists already we must delete first before trying to create it
if object_id('dbo.Test') is not null
begin
	drop table dbo.Test
end

-- now create the new table with an identity (autogenerated) Primary Key 
create table dbo.Test (TestId int identity(1,1) primary key, TestName varchar(25))
 
-- insert data into new table, do not insert into the identity because that is managed by the table identity
insert into dbo.Test (TestName)
	values ('Test direct insert')
	
-- return the results
select TestId, TestName from dbo.Test

-- drop if exists, then create a new stored proc to take in the TestName as a parameter and do the insert
if object_id('dbo.usp_InsertTest') is not null
begin
	drop procedure dbo.usp_InsertTest
end;
go

create procedure dbo.usp_InsertTest (@TestName varchar(25))
as
set nocount on

insert into dbo.Test (TestName)
	values (@TestName)
go

-- exec the stored procedure
declare @TestName varchar(25)
set @TestName = 'Test from proc'

exec dbo.usp_InsertTest @TestName

-- return the results
select TestId, TestName from dbo.Test