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

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.

No comments:

Post a Comment