0
In one of my earlier post , I have written about the multi row based constraint implementation in Oracle
http://mybicommunity.blogspot.in/2016/06/multi-row-based-constraints-in-oracle_8.html..
When I try to implement the same in SQL Server 2008 R2 , I'm not able to achieve it as a straight forward like in oracle but it is achieveable through computed column/view .
Below Link : Holds the approach suggested by MSDN people.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/392ebaa0-2546-4abf-a1ff-6a9199be4a32/help-create-index-with-substring?forum=transactsql
0Awesome Comments!