{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 戒情不戒烟 的问题《Does SQL Server 2008 support the CREATE ASSERTION》','https://www.manongdao.com/q-1249733.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
Does SQL Server 2008 support the CREATE ASSERTION syntax?
I haven't been able to find a straight answer on this.
相关问题
- SQL join to get the cartesian product of 2 columns
- sql execution latency when assign to a variable
- Difference between Types.INTEGER and Types.NULL in
- php PDO::FETCH_ASSOC doesnt detect select after ba
- Bulk update SQL Server C#
No, you'd use a CHECK constraint or a TRIGGER instead, depending on complexity.
SQL Server 2008 does not support
CREATE ASSERTION.In fact, no current SQL products support
CREATE ASSERTIONproperly. Sybase SQL Anywhere supports it but reportedly has problems allowing constraints to sometimes be violated. Rdb did support it when it was looked after by DEC (who apparently were influential in the early days of the SQL standards, probably the reason whyCREATE ASSERTIONis in the standard in the first place) but that product is no more.STOP PRESS: according to their documentation, HyperSQL (HSQLDB) supports assertions (though I'm left wondering why they don't shout about it on their list of features).
No SQL Server 2008 does not support this syntax.