Let me see if I understand your problem. You are trying to do a dynamic SELECT statement and you are putting a column name inside of the variable to complete your...

You can try to do something like this:

If exists(select * from table where key = @key)

insert into table (key,...)

values (@key,...)

else

return -1

...