How is validation controlled in SQL Server?

Discussion of issues, suggestions and bugs of Devart Excel Add-ins, our product line for connecting Excel to external data from cloud applications and databases
Post Reply
dwimberly
Posts: 2
Joined: Wed 12 Jul 2017 16:41

How is validation controlled in SQL Server?

Post by dwimberly » 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

Shalex
Site Admin
Posts: 8375
Joined: Thu 14 Aug 2008 12:44

Re: How is validation controlled in SQL Server?

Post by Shalex » 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.

Post Reply