How to create a stored procedure in SQL Server. ... To call, or execute the stored procedure, you must use either EXEC or the EXECUTE command. Worry not because both do the same thing.