How to test a dml trigger in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between value type and reference type?
How to update a field in SQL after ALTERING a row?
What are the restrictions that views have to follow?
What do you mean by acid?
How to execute multiple stored procedures at one time in sql server?
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
What are the recovery models for a database?
How do you make a trace?
What is conditional split?
Alternative way to DetDate() function?
Please tell me some knowledge about Clustering and how to add clustering?
What is system stored procedures?
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)