My question might seem a little complicated, i'll try my best to explain. I'm looking for software or some sort of method that allows me to validate data entered in a database. What i want to do is make sure that (for example) if field1 is 1 then field2 can't be null, field3 can only be between 1 and 10. I know that a query or stored procedure might do the trick, but i'm looking for something that is easier to manage, as i have to do this for various tables, all with hundreds of fields. This is in mssql btw.
Question
phirestarter
Hi there,
My question might seem a little complicated, i'll try my best to explain. I'm looking for software or some sort of method that allows me to validate data entered in a database. What i want to do is make sure that (for example) if field1 is 1 then field2 can't be null, field3 can only be between 1 and 10. I know that a query or stored procedure might do the trick, but i'm looking for something that is easier to manage, as i have to do this for various tables, all with hundreds of fields. This is in mssql btw.
Thanks for any help,
phire
Link to comment
Share on other sites
3 answers to this question
Recommended Posts