Kabiriel Anand Raj

Store procedure 

create database project
use project
Create Table projecttabledt(name varchar(50),age int,sex varchar(50))
insert into projecttabledt values('anand',22,'male')
select*from projecttabledt
alter procedure insertstrprocedure(@name varchar(50),@age int,@sex varchar(50))
as
begin
insert into projecttabledt values(@name,@age,@sex)
end
exec insertstrprocedure 'kumar',23,'male'
select * from projecttabledt