Exploring Thoughtz..

Posts Tagged ‘MS SQL

SQL Collations & Case Sensitive Searches

Posted by: Vijay Dev on: April 14, 2009

I got a question recently from a friend about doing case sensitive searches in SQL and I did not know the answer !! I knew that ORM’s like Django have operators such as ILIKE to do this, but I do not know how to do this in raw SQL. So I started looking for ways [...]

MS SQL – Comparing GUIDs

Posted by: Vijay Dev on: August 25, 2008

How to sort a given list of GUIDs (or) how to compare GUIDs ? This answers the question !

MS SQL – DateTime related Functions

Posted by: Vijay Dev on: August 24, 2008

Many a times I have come across code snippets that either format a timestamp value for displaying to the user or compare with another timestamp value. Often its much easier to let the database do the same. However, since the database needs to use functions on the columns to do these conversions, indexes on these [...]


Blog Stats

  • 24,266 Visitors

My Tweets

About Me

Journey so far…

Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.