Other than truncate statement, which other command can by-pass the trigger on the tables?
- 0 Answers
- 702 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to delete multiple rows with one delete statement in ms sql server?
What is a join in sql? What are the types of joins?
What are the joins in sql server? : sql server database administration
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
Explain what is raid and what are different types of raid levels?
What is inline table-value user-defined function?
Explain some stored procedure creating best practices or guidelines?
Which database stores information about replication?
Please differentiate between a local and a global temporary table?
What are explicit and implicit transactions?
What is the use of set nocount on/off statement?
explain what is raid and what are different types of raid configurations? : Sql server database administration
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
