Figure 2. Use T-SQL Batch Statements or Stored Procedures. A single parameterized T-SQL batch statement substitutes for an average 3.7 stored-procedure executions for InsertOrder and UpdateOrder operations. (NorthwindCS Orders records have an average 2.7 Order Details records.) Parameterized stored procedures are faster for GetOrder operations, but parameterized T-SQL batches run UpdateOrder operations more quickly and don't require client-side transaction management.