How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,

---

How to test a dml trigger in ms sql server?

0 Answers  

---

What are types of scd? : sql server analysis services, ssas

0 Answers  

---

Determine how to use the inserted and deleted pseudo tables?

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,

---

---

Explain different backup plans?

0 Answers  

---

List all the types of user-defined functions?

0 Answers  

---

How to get a list of columns using the "sys.columns" view in ms sql server?

0 Answers  

---

What are different types of constraints?

0 Answers  

---

Does the order of columns in update statements matter?

0 Answers  

---

Explain the concept of recursive stored procedure.

0 Answers  

---

Is trigger fired implicitely?

2 Answers  

---