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 - 2003-12-02 : 08:26:53
|
| Mike writes "I'm trying to find out (programattically using tsql with sql server 7) if a stored procedure parameter has a default value. My initial attempts were made using the sp_sproc_columns proc which returns a column called COLUMN_DEF that is supposed to return the column default. On further inspection, I found that this value is always set to null, and thus useless to me. I have also looked at sysobject, syscolumns, sysconstraints and syscomments but to no avail (although syscomments has the proc's code in the TEXT field, but I don't want to parse that if possible). Anyone know if it is possible to find this information, and if so, how?" |
|
|
|
|
|
Determining default values of Stored Procedures