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

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

Read the latest Blogs

Forums

https://probowl-bowl.com/

By streamlive

https://the-grammyawards.com/ https://the-grammyawards.com/2020/ https://the-grammyawards.com/live/ https://grammyawards-grammy.com/ https://grammyawards-grammy.com/2020/ https://grammyawards-grammy.com/live/ https://probowl-bowl.com/ https://probowl-bowl.com/2020/ https://probowl-bowl.com/live/ https://probowl-bowl.com/nfc-vs-afc/   https://the-grammyawards.com/ https://the-grammyawards.com/2020/ https://the-grammyawards.com/live/...

https://grammyawards-grammy.com/

By streamlive

https://the-grammyawards.com/ https://the-grammyawards.com/2020/ https://the-grammyawards.com/live/ https://grammyawards-grammy.com/ https://grammyawards-grammy.com/2020/ https://grammyawards-grammy.com/live/ https://probowl-bowl.com/ https://probowl-bowl.com/2020/ https://probowl-bowl.com/live/ https://probowl-bowl.com/nfc-vs-afc/

How to update status with conflict data where chemical temp table have same chem

By ahmed_elbarbary.2010

How to update status with conflict data where chemical temp table have same chemical...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers