Tag Archives: Learn SQL Server 2012 for Beginners

Difference between CHARINDEX and PATINDEX

Posted on July 4, 2013 by uday arumilli

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

Posted on July 3, 2013 by uday arumilli

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?

Posted on July 2, 2013 by uday arumilli

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