Subscribe
Categories
Archives
- October 2022
- July 2020
- May 2020
- September 2019
- April 2019
- December 2017
- October 2017
- September 2017
- August 2017
- July 2017
- June 2017
- May 2017
- April 2017
- March 2017
- January 2017
- December 2016
- November 2016
- October 2016
- July 2016
- June 2016
- May 2016
- April 2016
- March 2016
- February 2016
- December 2015
- November 2015
- October 2015
- September 2015
- August 2015
- July 2015
- June 2015
- May 2015
- April 2015
- December 2014
- November 2014
- October 2014
- September 2014
- February 2014
- January 2014
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- October 2012
- September 2012
- August 2012
- May 2012
- March 2012
- November 2011
- September 2011
- August 2011
- June 2011
- May 2011
- March 2011
- February 2011
- January 2011
- December 2010
- July 2010
- May 2010
- February 2010
- January 2010
- December 2009
Meta
Tag Archives: SQL Tips
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
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
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