What is transcation?Plz give One example?
Answers were Sorted based on User's Feedback
Answer / hari
Transcation is a sequence of operations performed as single
logical unit work .
Atomicity,consistency,isolation, Durabality
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / dev
Transaction is a process to handle cretical situation data
being inserted into table if any error comes into this
picture data will be rollbacked.
| Is This Answer Correct ? | 0 Yes | 1 No |
what are cursors? : Sql server database administration
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L
Why do we use sql limitations? Which constraints can we use while making a database in sql?
can we have a nested transaction? : Sql server database administration
What is log cache in sql server?
About Indexed Views? with example? plz reply...
How to change the ownership of a schema in ms sql server?
What are commonly used odbc functions in php?
What is the difference between ddl and dml?
Give a example to search fr a string in all stored procedure in sql server.
What are the components of sql server service broker?
What is a trigger in sql server?
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)