Hey Praveen,
SET @FIRST='HENRY%' - it will not select any records from AdventureWorks.Person.Contact for your query
"SELECT ContactID,FirstName,MiddleName,LastName WHERE FIRSTNAME=@FIRST
FROM AdventureWorks.Person.Contact"
So no record id inserted to CONTACT as such it...