How can we remove orphan records from a table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How can u convert the Date to String?

6 Answers   Microsoft, TCS,


Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,


What are null values in ms sql server?

0 Answers  


What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,


How do you set a trace flag in sql server?

0 Answers  






Why transaction is important?

0 Answers  


What is the difference between Clustered and Non-Clustered Index?

0 Answers  


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  


How to encrypt Strored Procedure in SQL SERVER?

0 Answers  


check, not null,unique

2 Answers   IBM,


Find nth lowest salary or get nth lowest salary?

0 Answers  


How to assign null values to variables or columns?

0 Answers  


Categories