What are the difficulties faced in cube development? : sql server analysis services, ssas
No Answer is Posted For this Question
Be the First to Post Answer
What is blocking and how would you troubleshoot it?
What is wide table?
Do you know what are acid properties?
how many type of subquery?
what is the maximum size of a row in sql server 2000 and 2005
What is the importance of three tier architecture?
What is collation sensitivity? Explain different types.
What command do we use to rename a db?
what is create database syntax? : Sql server database administration
What do you understand by the data quality services in sql server?
What is enhanced database mirroring in sql server 2008?
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
Oracle (3253)
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)