File Attachment Stored Procedures - Assistance Please

The following 2 stored procedures are used to insert and select attachments for a web application I'm creating. The stored porcedures work in the basic sense but when I do the insert only one record is inserted. Also, when I do the select only one record is selected.





I'm wondering if I there is suppose to be some sort of record counting or looping involved to insert and return all records. If there is, I would appreciate any advice and/or examples on the proper way of doing this.





If the code is also needed I'd be glad to post it as well.





Thanks








CREATE PROCEDURE AddAttachments


(


@FILENAME varchar(200),


@FILE_PATH varchar(2000),


@T_PK int


)


AS





INSERT INTO ATTACHMENTS (FILENAME, FILE_PATH, T_PK) VALUES (@FILENAME, @FILE_PATH, @T_PK);





GO








CREATE PROCEDURE SelectAttachments


(


@PK int


)


AS





SELECT FILENAME, FILE_PATH


FROM TASKINGS RIGHT OUTER JOIN


ATTACHMENTS ON T.PK = ATTACHMENTS.T_PK


WHERE (T_PK = @PK);





GO