55 lines
764 B
Plaintext
55 lines
764 B
Plaintext
CREATE PROCEDURE [dbo].[sp_StoredProcedureVersionsGet]
|
|
@StoredProcedure nvarchar(MAX)
|
|
,@Version int
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
SELECT [StoredProcedure]
|
|
,[Version]
|
|
FROM [dbo].[StoredProcedureVersions] where [StoredProcedure] = @StoredProcedure AND [Version] <= @Version
|
|
END
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|