sql server - Stored Procedure Query that adds parameter value to table -


i want create procedure adds parameter value different table. i've read, believe on right track, cant figure out go here:

create procedure addtonotificationtable @id int select *  images id = @id 

i want add @id parameter different table (notificationtable). please me out.

solved problem adding insert [table] (column).

before, query selecting record in table (images) id matched parameter. takes id , adds table (notificationtable).

create procedure addtonotificationtable @id int insert notificationtable (id) select id  images id = @id 

Comments