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       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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
 
Explain the basic concepts of SQL server architecture?  2
What are the differences between stored procedure and functions in SQL Server 2000? TCS12
how to generate XML out of QUERY? McAfee1
Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!  1
What are statistics, under what circumstances they go out of date, how do you update them? HCL2
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?  1
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database. Microsoft2
What is the use of MOVE keyword in restore command IBM2
write coding for importing sql data into a word excel... Oracle1
logshipping is Any difference 2000 and 2005?  1
Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query Wipro3
How can your resolve deadlocks? IBM3
what is Archive old data?  1
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.  4
How do you check the performance of a query and how do you optimize it?  1
What is Report Server,Report Manager and Report Builder in SSRS 2005?  1
What is the difference between views and stored procedures? Can we have input parameters for views?  3
What is WITH CHECK OPTION Karur-Vysya-Bank-KVB2
What is the difference between distinct clause and group by clause? Value-Labs1
What is the difference between IN and EXISTS operators in SQL Server? Intelligroup3
 
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