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
Post a Comment