CREATE PROCEDURE [dbo].[BO_AddUserFavoriteKnok] @userId int, @knokId int AS Insert UserFavoriteKnoks (UserId, KnokId) SELECT @userId, @knokId -- ignore errors EXEC BO_GetUserFavoriteKnoks @userId RETURN 0