Can I use CHECK constraints? What about a trigger? Can I validate multiple columns in a single pass?
Thanks,
Doug
How is validation controlled in SQL Server?
Re: How is validation controlled in SQL Server?
CHECK constraints and triggers work on the database side. Please enable Options > Edit > General > "Refresh all columns after commit" to retrieve the actual data inserted in the table.dwimberly wrote:Can I use CHECK constraints? What about a trigger?
Options > Edit > Error Handling > "Use transaction" allows you either insert all records or none of them if any error.dwimberly wrote:Can I validate multiple columns in a single pass?