How many nested transaction can possible in sql server?
Answers were Sorted based on User's Feedback
Answer / naveen
32 nested transaction can possible in sql server
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / naveen singh
three type of
(1)Begin
(2)Rollback
(3)commit
| Is This Answer Correct ? | 11 Yes | 25 No |
List out the differences between global and local temp tables in sql server?
When should you use an instead of trigger?
How would we use distinct statement? What is its use?
What are the differences between substr and charindex in sql server.
What is difference between inner join and join?
Can XML be used to access data?
What are user-defined functions (udfs) in sql server?
How do you identify a foreign key?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What is a job?
How to find tables without indexes?
When would you use sql joins?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)