Category Archives: SQL Development

How to find highest salary in sql

  How to find highest salary in sql We had a situation where we have to find out all the details of a product with the Nth highest price Note: Some of the products are in the same price range. … Continue reading

Posted in SQL Development | Tagged , , , , , , , , | 2 Comments

Difference between CHARINDEX and PATINDEX

Difference between CHARINDEX and PATINDEX CHARINDEX: It is a string function which returns the starting position of a pattern. PATINDEX: It is a string function which returns the starting position of a pattern. We can also use wildcard characters in … Continue reading

Posted in SQL Development | Tagged , , , , , , , , | Leave a comment

Conversion functions in SQL Server 2012

Conversion functions  in SQL Server 2012   Before starting with “Conversion functions in SQL Server 2012” we’ll have a look into “Why data conversion needed?” Does SQL Server can’t do it automatically? Yes! SQL server can do data conversion internally … Continue reading

Posted in SQL Development | Tagged , , , , , , , , , | Leave a comment