Retrieve default value for parameter in procedure

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

2002-05-10

305 reads

Blogs

T-SQL Tuesday #121: Gifts received for this year

By

At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve...

T-SQL Tuesday Gifts (#121)

By

It’s that time of month. I missed last month while traveling, but I wanted...

Speakers wanted for the Richmond (VA) SQL Server Users Group – 2020

By

Are you a speaker in SQL Server topics? Come on out to Richmond, VA...

Read the latest Blogs

Forums

logfile (whitespace) and excessive growth

By apostolisep3

Hello guys , i am working with sql server 2017 about a year and...

Creating Split backups Question

By Lee Hopkins

When creating a split backup is it required to have each of the splits...

Star- and Snowflake Schema in MOLAP

By ktflash

Ahoi, the difference between Star- and Snowflake obviously makes a difference in performance for...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers