Error With Identity Column

 hi,

As i have created a table with a identity column and now i am using a procedure to insert the values into that table....but when i execute it it gives an err saying err converting varchar data to int and also on the asp.net ......plz help me out for the procedure and the using it with sqlcommand in .net.

 

create table demo2(id int identity(1,1),name varchar(20))

create procedure sp_demo2

(@id int,@name varchar(20))as begin

insert into demo2(name) values(@name)

set @id=@@identity

end

 

exec sp_demo2 'j'

thanks,

rajiv