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

307 reads

Blogs

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

Daily Coping 14 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

WIT Mental Health and Wellness Videos Posted

By

I was honored to speak at the WIT Mental Health and Wellness day last...

Read the latest Blogs

Forums

unable to deploy package unable integration service catalog

By atulyan.aries

Hi I get teh following error while deploying package .NET Framework error occurred during...

Limit database restores to specific drive locations

By DrJogalog

As there isn't an option to use a DDL trigger on a RESTORE query,...

VLOOKUP Equivalent in SQL

By Sarah1997

Hi there I have two tables, one with an ID and Amount (Table 1)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Container Logs

See possible answers