As you were probably aware, last Friday we had techweets which was an initiative by South Asia MVPs to post day long technical tweets. In case you missed it, I’m sharing the tips through this blog which I’d tweeted as…
Techweets- Whole day technical tweets
Techweets is happening. Day full of technical tips as tweets from South Asia MVPs @IndiaMVP. I’m posting techtip every 30 mins. Follow my tweets at #techweets @IndiaMVP
Object Filtering using SSMS object explorer
A little known but very useful feature in SQL Server Management Studio (SSMS) is the ability to filter objects (tables, stored procedures etc) by specifying a variety of filter conditions. This particularly comes handy in cases where you need to…
Wildcard based character search using PATINDEX
This is a follow up of the below blog on wildcard character based searchhttp://visakhm.blogspot.in/2013/01/wildcard-character-based-pattern-search.html Extending this further, I did some experiments on how various wildcard characters will work inside pattern in t-sql .Lets see how we can apply similar logic…