Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
MS SQL Server Interview Question:
What Is a Transact-SQL Statement Batch in MS SQL Server?
Submitted by: AdministratorA batch is a group of one or more Transact-SQL statements sent at the same time from an application to SQL Server 2005 for execution. SQL Server compiles the statements of a batch into a single executable unit, called an execution plan. The statements in the execution plan are then executed one at a time. How to define and send a batch is depending on the client application you are using. For example:
# You need to use the GO command in "sqlcmd" tool to end a batch and send it to SQL server.
# SQL Server Management Studio also uses GO command to separate batches when multiple statements are selected for execution.
# In ADO, a batch is defined as all the statements entered in the CommandText property of a Command object.
Submitted by: Administrator
# You need to use the GO command in "sqlcmd" tool to end a batch and send it to SQL server.
# SQL Server Management Studio also uses GO command to separate batches when multiple statements are selected for execution.
# In ADO, a batch is defined as all the statements entered in the CommandText property of a Command object.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.