Answer Posted / visala
yes, we can have nested transactions. to know the nest
level use @@trancount
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is the difference between a view and a stored procedure?
What are synonyms?
Do you know what are the steps to process a single select statement?
What is the synonym of join?
When would you use a before or after trigger?
Explain an automatic checkpoint
how to use DTS package in 2000,2005,2008 in sql server
How to verify a login name with sqlcmd tool?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Explain the various types of concurrency problem?
What methods do you follow to protect from sql injection attack?
What is report snapshot?
What is data file in computer?
