Development Note: May 2011

Tuesday, May 3, 2011

Case Sensitive search In Microsoft SQL Server,

In Microsoft SQL Server, in that the case if you query for some thing with where clause which is case sensitivity search then you have to follow as below.

declare @addr nvarchar(20)

set @addr ='123 strEet'

select @addr where @addr like '%ree%'

select @addr where @addr like '%rEe%'

select @addr where @addr COLLATE SQL_Latin1_General_CP1_CS_AS like '%ree%'

select @addr where @addr COLLATE SQL_Latin1_General_CP1_CS_AS like '%rEe%'

Code Formater

Paste Here Your Source Code

Source Code Formatting Options

1) Convert Tab into Space :
2) Need Line Code Numbering :
3) Remove blank lines :
4) Embeded styles / Stylesheet :
5) Code Block Width :
6) Code Block Height :
7) Alternative Background :

Copy Formatted Source Code

Preview Of Formatted Code