Tag Archives: T-SQL

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

What is the Difference between NUMERIC / DECIMAL and FLOAT / REAL in SQL Server 2012?

What is the Difference between NUMERIC / DECIMAL and FLOAT / REAL Q. What is the Difference between NUMERIC / DECIMAL and FLOAT / REAL in SQL Server 2012? Ans: Before dig into these data types we must have a … Continue reading

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