Stored procedures
To update the code of stored procedures:
-
Run
ALTER GIT REPOSITORY <name> FETCH
to propagate changes (doc) -
If using
create_all.sql
to mass-create the stored procedures, re-run:EXECUTE IMMEDIATE FROM @sentry_repo/branches/main/deployment_models/git-repository/create_all.sql;
Otherwise, if running individual queries using
EXECUTE IMMEDIATE
, nothing needs to be done since it will automatically use the latest version from the repository.