Is is possible, directly, or by executing SQL code, to obtain the default value for an imput parameter declared in a stored procedure?
eg
CREATE PROCEDURE [test]
(
@test nvarchar(255) = "some default value"
)
AS
INSERT INTO test (test)
VALUES (@test)
GO
I want to get the "some default value" value from my application.