Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 sql scope issue

Author  Topic 

sqllearner
Aged Yak Warrior

639 Posts

Posted - 2004-08-10 : 18:35:38
Iam modifying a stored procedure and in that I saw something

CREATE PROCEDURE dbo.usp_admin
@id int,
@data_name varchar(20),
@stored_procedure_name varchar(10),
@data_type_id int,
@FromDAL char(1) = 'N'

AS

.........
.........

@FromDAL = 'N' -- if called from outside of SQL scope

what does this mean.Does this mean that if called from application.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-10 : 19:15:14
That is specific to that stored procedure and isn't something that we can answer without seeing the entire sproc. The author was probably thinking that if the sproc was called from QA, then you'd pass it Y, else N for from the app.

Tara
Go to Top of Page
   

- Advertisement -