When does Delete statement fails?

 Posted by vishalneeraj-24503 on 7/31/2014 | Category: Sql Server Interview questions | Views: 234 | Points: 40
Answer:

Mostly Delete statement fails:-
When there is a violation of Foreign key meaning that idf we delete a parent key but it's references are present on child table.
When there is written wrong statement as Delete * from tablename.
When supplied column is not present.
When the column value has different datatype.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response