Wednesday, September 29, 2010

Select Case Sensitive String from Table in Sql Server

I have a Table in which record is following



Name               Age

nagendra           23

NAGENDRA   24



SELECT  Name,Age FROM Customers

WHERE  Name COLLATE Latin1_General_CS_AS = 'nagendra'



Output:

nagendra
-
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Mat Table Angular

Mat Table in Angular Mat table is used to display data . its a material designed styled data-table . For using Material Table MatTableMo...

  • Apply Criteria on XPCollection
    CriteriaOperator criteria = new BinaryOperator("Age", 30, BinaryOperatorType.Greater); CriteriaOperator criteria = CriteriaOperato...
  • How To Sort a XPCollection
    SortingCollection sc = new SortingCollection(); sc.Add (new SortProperty("field on which you want to sort",DevExpress.Xpo.DB.Sorti...
  • Angular Build Minification and Uglification
    Minification and Uglyfication in Angular Deployement Minification : While building Angular Application white spaces , unused variable , u...