Re: how to know if the Stored procedure is used to retrieve data or not
From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 11/24/04
- Next message: Aaron [SQL Server MVP]: "Re: how to know if the Stored procedure is used to retrieve data or not"
- Previous message: Michael C: "Re: Question for Joe Celko - Improved Soundex from SQL for Smarties"
- In reply to: darkStar_E2: "how to know if the Stored procedure is used to retrieve data or not"
- Next in thread: Aaron [SQL Server MVP]: "Re: how to know if the Stored procedure is used to retrieve data or not"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Nov 2004 03:41:44 -0000
Using a good naming convention helps. For example you can name your procs
like this:
usp_table_name_insert
usp_table_name_update
usp_table_name_delete
usp_table_name_select
If you don't have a naming convention and you need to determine what
operations are performed by existing SPs then you'll have to examine the
source code somehow. Script all the SPs using Enterprise Manager and then
inspect or search the source code.
-- David Portas SQL Server MVP --
- Next message: Aaron [SQL Server MVP]: "Re: how to know if the Stored procedure is used to retrieve data or not"
- Previous message: Michael C: "Re: Question for Joe Celko - Improved Soundex from SQL for Smarties"
- In reply to: darkStar_E2: "how to know if the Stored procedure is used to retrieve data or not"
- Next in thread: Aaron [SQL Server MVP]: "Re: how to know if the Stored procedure is used to retrieve data or not"
- Messages sorted by: [ date ] [ thread ]
