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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-28 : 23:58:12
|
Norman writes "Other than in the sp text in syscomments, where is the default value for a stored procedure parameter stored?
CREATE PROCEDURE test1 @i INT , @c CHAR(1) , @c2 VARCHAR(3) = 'hello'
AS
...
Where is the default value of 'hello' stored fo the parameter @c2 in a way that I can join to it with the stored procedure object id and not have to parse through the stored procedure text in syscomments?
I have looked in syscolums and checked the INFORMATION_SCHEMA views and PROPERTY functions.
SQL Server 7.0 SP3
Windows NT SP6
Thanks,
Norman" |
|
|
|
|
|
Stored Procedure Paramter Default