Is it possible to save and reuse a parameter set as a code block in SQL Server Express 2005?

I have several stored procedures that use the same set of parameters. Is there a way to define and save a list of parameters as a reusable block of code? Something like that:

CREATE PROCEDURE test
    Using StoredParameterList 
AS
BEGIN
    SQL Statement
END

Is it possible? This would make code maintenance easier if a parameter needs to be changed.

+3
source share
1 answer

, . , Sql Server , . , , , UDT.

0

Source: https://habr.com/ru/post/1729598/


All Articles