Thanks to all of you guys for giving me good information and the code is working fine now. Can u guys suggest some stored procedure samples that i can try...

I am trying to write a stored procedure to insert values into a table which is already created.

my code is

Create procedure name

@value varchar(50),

@value2 varchar(150)

as

begin

declare @myValue int

Select @myValue =...