Answer / Pervinder Singh

Change Tracking in SQL Server is a feature that allows you to track all changes made to tables, including insertions, updates, and deletions. It provides a table-valued function for querying the changes, which can help with auditing and reporting purposes.

Explain about local stored procedure?

1 Answers  

---

How to handle error or exception in sql?

1 Answers  

---

What are the differences between char and varchar in ms sql server?

1 Answers  

---

Can you explain different types of joins?

1 Answers  

---

What is the difference between substr and charindex in the sql server?

1 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,

---

Do you know what is difference between stored procedure and user defined function?

1 Answers  

---

What is the exact numeric data type in sql?

1 Answers  

---

What are the differences between union, intersect, and minus operators?

1 Answers  

---

What is the use of CASCADE CONSTRAINTS?

3 Answers  

---

What are different types of constraints?

0 Answers  

---

What is data source view or dsv? : sql server analysis services, ssas

1 Answers  

---