How to test a dml trigger in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What are types of storage modes? : sql server analysis services, ssas
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 verify a user name with sqlcmd tool?
Explain Active/Active and Active/Passive cluster configurations?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What is difference between index and primary key?
How to copy data from one table to another table?
Write a sql query to delete duplicate records from a table called table1
How to create a local temporary stored procedure?
Explain the third normal form(3nf)?
Explain in brief how sql server enhances scalability of the database system?
diffrence between Cluster Index and non Cluster Index
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)