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 - 2004-03-24 : 08:41:48
|
| Ashton writes "I am trying to write a process that will extract information about a stored procedure so that I can generate .NET code calls for the procedure.The problem I am having is determing if a stored procedure parameter has a default value assigned to it. I've looked in syscolumns and can't find anything and I've also looked in information_schema.parameters and cannot determine if a stored procedure parameter takes a default value. Is there any way looking at the sys catalog to determine whether a procedure parm takes a default value and if so, what its value is?Thanks" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-03-24 : 16:58:11
|
| I believe that information is only available by looking at the source in syscomments as it is evaluated at runtime.Damian |
 |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2004-03-24 : 20:34:22
|
| A possible work around would be to store the default values in the Extended Properties of the sproc and query those.Justin"Hit me with a shovel 'cause I can't believe I dug you." |
|
|
|
|
|
|
Stored Procedure Parameter Info