问使用开始和结束在Server 2008中创建存储过程

EN

ALTER PROCEDURE [dbo].[SampleTable]
AS 
BEGIN
    BEGIN
    WITH 'Test' AS
    (
        SELECT * FROM dario1
        UNION ALL
        SELECT * FROM dario2
        UNION ALL
        SELECT * FROM dario3
    )
    END 

    IF select Column1 = 1 FROM Test
    BEGIN
      --another commands.. etc..
    END

    IF select Column1 = 2 FROM Test
    BEGIN
         --another commands.. etc..
    END

    IF select Column1 = 3 FROM Test
    BEGIN
         --another commands.. etc..
    END
END