Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sirisha
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 ? | 11 Yes | 6 No |
Post New Answer View All Answers
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What is the name of the Database which IBM mainframe uses?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What is meant by indexing files?
When to use null data driven subscription?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What is bit data type? What's the information that can be stored inside a bit column?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
how to trace the traffic hitting a sql server? : Sql server database administration
State the difference between local and global temporary tables?
Why we need to use secondry database file? though, we can do same work using primary database file also.
How to create new tables with "select ... Into" statements in ms sql server?
how would you troubleshoot blocking? : Sql server database administration
What is difference between view and materialized view?
What is sql sandbox in sql server?
