Phil Parkin (8/2/2013)
Presumably you are using some sort of front-end application (Winform/Web) to get this info from the user. This validation should be done there and not by SQL Server.
Thanks a lot for your reply . what ever you are saying is correct , but in our company we put all the validation from SQL Server, using SP(stored procedure). SO that if the requirement is changed we can easily edit the SP. So please help me sir 🙁