Knocks/BackEnd/Knoks.Operate/Stored Procedures/BO_AddUserFavoriteKnok.sql

8 lines
212 B
Transact-SQL

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