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


305 reads


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


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

T-SQL Tuesday Gifts (#121)


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


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

Read the latest Blogs


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


SQL Server Q&A from the SQLServerCentral community

Get answers