26 April 2009

🛢DBMS: Batch (Definitions)

"One or more Transact-SQL statements terminated by an end-of-batch signal, which submits them to SQL Server for processing." (Karen Paulsell et al, "Sybase SQL Server: Performance and Tuning Guide", 1996)

"A set of SQL statements submitted together and executed as a group. A script is often a series of batches submitted one after the other." (Patrick Dalton, "Microsoft SQL Server Black Book", 1997)

"Denotes a set of statements executed together." (Owen Williams, "MCSE TestPrep: SQL Server 6.5 Design and Implementation", 1998)

"A set of SQL statements submitted together and executed as a group. A script is often a series of batches submitted one after the other. A batch, as a whole, is compiled only one time and is terminated by an end-of-batch signal (such as the GO command in SQL Server utilities)." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"A set of SQL statements submitted together and executed as a group. A script is often a series of batches submitted one after the other." (Anthony Sequeira & Brian Alderman, "The SQL Server 2000 Book", 2003)

"Multiple batches can be combined in a single script or procedure using the GO Keyword to separate the batches. A collection of zero, one, or more T-SQL statements sent to SQL Server to be run together." (Thomas Moore, "EXAM CRAM™ 2: Designing and Implementing Databases with SQL Server 2000 Enterprise Edition", 2005)

"A collection of zero, one, or more T-SQL statements sent to SQL Server to be run together. Multiple batches can be combined in a single script or procedure, using the GO keyword to separate the batches." (Thomas Moore, "MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005", 2006)

"A set of requests or transactions that have been grouped together." (Microsoft, "SQL Server 2012 Glossary", 2012)

"A group of commands or statements.  A Client-Library command batch is one or more Client-Library commands terminated by an application’s call to ct_send. For example, an application can batch together commands to declare, set rows for, and open a cursor. A Transact-SQL statement batch is one or more Transact-SQL statements submitted to an Adaptive Server by means of a single Client-Library command or Embedded SQL statement." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
Koeln, NRW, Germany
IT Professional with more than 25 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.