What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

---

Can you pass expressions to stored procedure parameters?

0 Answers  

---

how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

---

How to create a testing table with test data in ms sql server?

0 Answers  

---

What purpose does the model database server?

0 Answers  

---

what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

---

What is difference between order by and group by?

0 Answers  

---

How are the unique and primary key constraints different?

0 Answers  

---

How can we get count of the number of records in a table?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

Is truncate a dml command?

0 Answers  

---