Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Retrieve default value for parameter in procedure

By Eve,

This procedure will return DEFAULT value for the parameter in the stored procedure. Usage: Use pubs go declare @Value varchar(30) exec _GetParamDefault 'random_password','@password_type',@value OUTPUT SELECT @VALUE Also accepts different versions, by default, if not specified, first version info retrieved. exec _GetParamDefault 'random_password;2','@password_type',@value

Total article views: 302 | Views in the last 30 days: 1
 
Related Articles
FORUM

Passwords

Storing passwords securely

FORUM

password issues

password issues

FORUM

Password change

Password change

FORUM

password polacy

password polacy

FORUM

password policies

password policies

Tags
miscellaneous    
sqlinsider scripts    
t-sql    
 
Contribute