ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
what are batch in sql server?
 Question Submitted By :: Sam
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what are batch in sql server?
Answer
# 1
Batch is nothing but a set of sql statments that are 
executed at time (all the stmts will be exceuted or none(if 
any error encountered))

eg:
use [database]
GO
select empname from employee
insert employee(empno,empname)
select empno =1
,empname ='A'
GO
 
Is This Answer Correct ?    2 Yes 0 No
Sirisha
 
  Re: what are batch in sql server?
Answer
# 2
Batch in Sql server is a set of one or more Transact-SQL 
statements sent from a client to an instance of SQL Server 
for execution and it will represents a unit of work 
submitted to the Database Engine by users.
 
Is This Answer Correct ?    2 Yes 0 No
Kumar
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How do you use DBCC statements to monitor various aspects of a SQL server installation?  1
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables? TCS3
What does it mean to have quoted_identifier on? What are the implications of having it off?  2
what is IDE,DMV in sql server? Value-Labs1
can you any body tell me which service pack is installed in the sql server?  3
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records. 247Customer3
How to Generate a Series of Random Integers With T-SQL?  1
How do you know which index a table is using?  4
can any one please send sql quries most used in applications.  1
Which stored procedure will you be running to add a linked server?  1
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? HCL1
What is the basic difference between clustered and a non-clustered index?  3
what is meant by sql injection with example and one more question how to catch the errors in sqlserver  1
When you first load SQL SERVER you will startup with what all databases? CompuSol3
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.  1
Wht is Stuff in sql ser  1
What is the difference between distinct clause and group by clause? Value-Labs1
How do SQL server 2000 and XML linked?  2
How would you Update the rows which are divisible by 10, given a set of numbers in column?  1
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?  1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com