Is it best way put all the validation rules on insert/update/delete stored procedure?

Is it best way put all the validation rules on insert/update/delete stored
procedure?
When the failure happen from the validation rules, it will return all errors
to client.Hi
http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html
"ABC" <abc@.abc.com> wrote in message
news:%23D9HmCM8FHA.3044@.TK2MSFTNGP10.phx.gbl...
> Is it best way put all the validation rules on insert/update/delete stored
> procedure?
> When the failure happen from the validation rules, it will return all
> errors to client.
>