Devart Forums

Posted: **Wed 12 Jul 2017 17:28**

Can I use CHECK constraints? What about a trigger? Can I validate multiple columns in a single pass?

Thanks,

Doug

Posted: **Tue 18 Jul 2017 14:30**

dwimberly wrote:Can I use CHECK constraints? What about a trigger?

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 validate multiple columns in a single pass?

Options > Edit > Error Handling > "Use transaction" allows you either insert all records or none of them if any error.

Devart Forums

How is validation controlled in SQL Server?

How is validation controlled in SQL Server?

Re: How is validation controlled in SQL Server?