How load value default parameters sql stored procedure?

Question

1.00/5 (1 vote)

See more:

SQL

from StoredProcedureParameter parameter in                                        svr.Databases[""].StoredProcedures[""].Parameters
where !string.IsNullOrEmpty(parameter.DefaultValue)
select parameter.Name

Don't work.

Posted 11-Feb-15 21:07pm

andrey91

Add a Solution

Comments

John C Rayan 12-Feb-15 4:36am

HiCan you please explain with more details?

andrey91 12-Feb-15 6:37am

Hello. there is a procedure

CREATE PROCEDURE [dbo].[Proc]
@Param1 VARCHAR(50),
@Param2 INT = 111,
@Param3 VARCHAR(30) = NULL
AS
BEGIN
SET NOCOUNT ON

END
Param2 set by default.
I want to get the value Param2.

John C Rayan 12-Feb-15 7:02am

If the parameter is not defined as output param , then I doubt you could do it from application code.

andrey91 12-Feb-15 7:17am

var conn = new SqlConnection("ConnectionString";");
conn.Open();
Server srv = new Server(new ServerConnection(conn));

srv.ConnectionContext.Connect();

Database db = srv.Databases["DATABASE"];
foreach (StoredProcedureParameter param in db.StoredProcedures["PROCNAME"].Parameters)
{
string paramName = param.Name;
var dataType = param.DataType;
object defaultValue = param.DefaultValue;
}
param.DefaultValue always equal ""

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

nirav raval · Accepted Answer · 2015-02-11T23:29:00

Solution 1

If this is what you are looking for

Figure Out the Default Values of Stored Procedure Parameters[^]

Posted 11-Feb-15 23:29pm

nirav raval

Comments

andrey91 12-Feb-15 6:32am

Thank U. I would like to do just means .NET Framework