﻿-------------------------------------------------------------------------------
-- <copyright company="Sherlock">
--     Copyright 2013 Sherlock. Licensed under the Apache License, Version 2.0.
-- </copyright>
-------------------------------------------------------------------------------

CREATE PROCEDURE [Tests].[GetTestStepsByTestEnvironmentId]
    @id INT
AS
    SELECT
        [pk_TestStepId]
    FROM [Tests].[TestStep]
    WHERE [fk_TestEnvironmentId] = @id

{'avg_line_length': 34.357142857142854, 'max_line_length': 81, 'alphanum_fraction': 0.44282744282744285, 'licenses': ['Apache-2.0'], 'repository_name': 'pvandervelde/Sherlock', 'path': 'src/shared.database/Test/Programmability/Stored Procedures/GetTestStepsByTestEnvironmentId.sql', 'size': 483, 'lang': 'SQL'}