All stored procedures in the "Data" database are created automatically by the
procedures in the "Schema" database.
On the right there is a list of all stored procedures created for the sample
schema we use throughout this site.
The procedures are optimized for performance and rely on indexes created
automatically as well.
Below is an example of one of the stored procedures. It is recommended not to
edit these procedures, as they will be recreated every time the schema is changed.
If you need a custom procedure create it from scratch and do not use the reserved
CREATE PROCEDURE dbo.SP$_Find_user_by_country
set nocount on