Execute Sql Server Stored Procedure With Input Parameter

Could you suggest please how to execute from Sql Server a stored procedure that receives an input parameter? I tried this but it failed: EXEC GetFilmsInCategory('SF'); The stored

Solution 1:

TRY:

EXEC GetFilmsInCategory 'SF'

Solution 2:

You can also address the parameters by name:

EXEC GetFilmsInCategory @CatNume='SF'