How to know whether our backup is succesfully taken?
How to insert a new row into a table with "insert into" statements in ms sql server?
what is a live lock? : Sql server database administration
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What are the dmvs?
In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2
how to overcome kernel isssues
Explain various data region available in ssrs with their use?
How to drop existing views from a database in ms sql server?
What are number line correlation administrators will use while working with a subquery?
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.
Find nth lowest salary or get nth lowest salary?
What is transaction server consistency?
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)