Once the primary key is removed two things will happen:1. The clustered index is also removed which decreases performance and2. The table would then allow duplicate data to be inserted causing data corruption.
This is the inbuilt funcion of Sql server that gives you the difference between two diffrent dates as days "dd", month "mm" and year "yyyy" also at the place of formate s...