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

304 reads

Blogs

What does the Machine Learning process look like?

By

This is the second article in the Machine Learning area. I have explained a...

Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions

By

In this article, we will focus on creating a data pipeline to ETL (Extract,...

Quick 6 month check – how are those learning goals going…?

By

So in January I wrote a blog post on some goals I had this...

Read the latest Blogs

Forums

DB Snapshot on TDE Enabled Database

By GonnaCatchIT

Dear All, I have a DB on which TDE is enabled. When trying to...

Installing SQL 2017 Error

By garryha

I am trying to install SQL Server 2017 Enterprise Edition.  It is an Iso...

Select n records in table X from a field on table Y

By luisalfonso70

Hi, hope someone can help with this. I've the table gifts_to_give: Id_give      number_of_gifts          name ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Intersection

See possible answers