July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – Reverse String Word By Word

December 6, 2014
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String
Earlier I wrote a blog post where I have reversed the entire string which was passed to the function. You can read that over here User Defined Functions (UDF) to Reverse String. In that blog post I wrote a function which would reverse an entire string. However, recently I read…
Read More

SQL SERVER – Puzzle – ISNUMERIC and Unexpected Results – SQL in Sixty Seconds #076

October 29, 2014
Pinal Dave
SQL Video
SQL Function, SQL in Sixty Seconds, SQL Server

It has been a long time since I have asked, puzzled on this blog so let us have fun time together with ISNUMERIC function. If you get the correct answer to this question, I will give you one month free subscription to Pluralsight.

Read More

SQL SERVER – Script to Find First Day of Current Month

August 14, 2014
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DateTime, SQL Function
Earlier I wrote a blog post about SQL SERVER – Query to Find First and Last Day of Current Month and it is a very popular post. In this post, I convert the datetime to Varchar and later on use it. However, SQL Expert Michael Usov has made a good…
Read More

MySQL – UDF – Validate Integer Function

July 26, 2014
Pinal Dave
SQL, SQL Tips and Tricks
MySQL, SQL Function
There is a default function in SQL Server called ISNUMERIC to determine if the string is numeric. In SQL Server ISNUMERIC returns 1 for non numerials also. Ex ISNUMERIC (‘,’) returns 1. To avoid this you can write a user defined function as shown over here. In MySQL, there is…
Read More

SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?

December 29, 2013
Pinal Dave
SQL Tips and Tricks
MySQL, PostgreSQL, SQL Function, SQL Scripts, SQL Server

As a regular reader, you may know that I now a days work with MySQL and SQL Server both at the same time. Working with two different products have changed quite a few things in how I write code. Here is an example of that – I changed myself about how I CONCAT strings.

Read More

SQL SERVER – Building Three-Part Name from OBJECT-ID – Database Name, Schema Name, TableName

November 28, 2013
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function
Here is the question I recently received based on my earlier blog post – SQL SERVER – Get Schema Name from Object ID using OBJECT_SCHEMA_NAME. “How I get three part name if the only thing I have is object_id and current database context. What I mean is that, when I…
Read More

SQL SERVER – Implementing IF … THEN in SQL SERVER with CASE Statements

November 4, 2013
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function
Here is the question I received the other day in email. “I have business logic in my .net code and we use lots of IF … ELSE logic in our code. I want to move the logic to Stored Procedure. How do I convert the logic of the IF…ELSE to…
Read More
Previous 1 … 21 22 23 24 25 26 27 … 52 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version