`map`比`each`更快吗？(Is `map` faster than `each`?)

 我现在没有SQL SERVER，但对于SQL 2014 x64，它将是： 
 
 
 
 在这里您可以找到要下载的ms文件的链接： 从此处获取您需要从列表中查看： 
 
 
 ENU \ 64 \ SQLSysClrTypes.msi 
 
 ENU \ 64 \ SharedManagementObjects.msi 
 
 下载它安装并重新启动。 
 
 
 
 这里有完整的方法代码（ 请在此过程中将sql连接字符串参数更改为服务器连接字符串 ）： 
public static bool RunScriptsInTransaction(string script)
{
    SqlConnection con = new SqlConnection();
    con.ConnectionString = "Server=YourSqlServer;Initial Catalog = YourDbName;User Id=YourUserName;Password=YourPassword;";
    con.Open();

    ServerConnection sCon = new ServerConnection(con);
    sCon.BeginTransaction();
    try
    {
        sCon.ExecuteNonQuery(script);
        sCon.CommitTransaction();
    }
    catch (Exception e)
    {
        sCon.RollBackTransaction();
        return false;
    }
    finally
    {
        con.Close();
    }
    return true;
}
 
 
 要运行它只需写： 
 
        RunScriptsInTransaction(@"
    ALTER PROCEDURE [dbo].[usp_TestProcedure] 
      AS
      BEGIN

         SET NOCOUNT ON;
         PRINT 'Good evening'
     END

    GO
    ");

I do not now what SQL SERVER you have but for SQL 2014 x64 it will be:
 
 
 
Here you have link to ms files to download: Get it from here You need to check from list:
 
 
ENU\x64\SQLSysClrTypes.msi
 
ENU\x64\SharedManagementObjects.msi
 
Download it install and reboot.
 
 
 
Here you have whole code for method (Please change sql connection string parameters to your server connection string in this procedure):
 
public static bool RunScriptsInTransaction(string script)
{
    SqlConnection con = new SqlConnection();
    con.ConnectionString = "Server=YourSqlServer;Initial Catalog = YourDbName;User Id=YourUserName;Password=YourPassword;";
    con.Open();

    ServerConnection sCon = new ServerConnection(con);
    sCon.BeginTransaction();
    try
    {
        sCon.ExecuteNonQuery(script);
        sCon.CommitTransaction();
    }
    catch (Exception e)
    {
        sCon.RollBackTransaction();
        return false;
    }
    finally
    {
        con.Close();
    }
    return true;
}
 
 
To run it just write:
 
        RunScriptsInTransaction(@"
    ALTER PROCEDURE [dbo].[usp_TestProcedure] 
      AS
      BEGIN

         SET NOCOUNT ON;
         PRINT 'Good evening'
     END

    GO
    ");