Procedure in SQL Server

Create PROCEDURE ins


@name varchar(50),

@age float

as

insert into Emp(name,age) values(@name,@age)



Execute Procedure



ins 'Raj',22