有没有办法在SQL Server的存储过程中使用脚本？

CREATE PROCEDURE MyStoredProcedure
AS
BEGIN
    -- 声明变量
    DECLARE @Variable INT;
    
    -- 设置变量的值
    SET @Variable = 1;
    
    -- 条件判断
    IF @Variable > 0
    BEGIN
        -- 执行某些操作
        PRINT 'Variable is greater than 0';
    END
    ELSE
    BEGIN
        -- 执行其他操作
        PRINT 'Variable is less than or equal to 0';
    END
    
    -- 循环
    DECLARE @Counter INT;
    SET @Counter = 1;
    
    WHILE @Counter <= 10
    BEGIN
        -- 执行循环体内的操作
        PRINT 'Counter: ' + CAST(@Counter AS VARCHAR);
        SET @Counter = @Counter + 1;
    END
END