Wednesday, 14 September 2016

Create index with substring in SQL Server


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

No comments:

Post a Comment