Stored procedures

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 prefix 'SP$_'.

CREATE PROCEDURE dbo.SP$_Find_user_by_country
@country varchar(890)
as
set nocount on

select [user].[id],
[user].[firm_id],
[user].[username],
[user].[FirstName],
[user].[LastName],
[user].[Age],
[user].[Address],
[user].[city],
[user].[state],
[user].[zip],
[user].[country],
[user].[email],
[user].[comments],
[user].[created_on],
[user].[updated_on]
from [user]
with (index(IX_user_country))
where
         [country]=@country
GO