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

309 reads

Blogs

Daily Coping 5 Aug 2021

By

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

Interview Tip: Know your resume

By

Seriously. Make a point of reading your resume before submitting it, and again before...

SQL Server on Kubernetes Book Published!

By

I’m super proud to announce that Ben E. Weissman and I have published SQL...

Read the latest Blogs

Forums

private messages gone

By frederico_fonseca

hi, Maybe I'm doing something wrong now, but it seems that the option to...

How to get spid of jobs that are running along with job name

By coolchaitu

Hi, Can you please let me know how to get spid of jobs that...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers