RE: assertions – SQLServerCentral

SSC Guru

Points: 323504

February 8, 2013 at 1:25 pm

Mike Seattle (2/8/2013)
OMG! I've worked with SQL Server for over 10 years and I've never heard of assertions. Really. This is the first time I hear there is something like that in SQL Server. Maybe I am the idiot :w00t:

Neither SQL Server, Oracle Nor MYSQL support Assertions either;

it think this is one of those Things Celko thought was great in theory and injected into some obscure ANSI standard, but noone else thought it worthy, and ignored implementing it.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!