SQL String « SQL Server Journey with SQL Authority

Archive for the ‘SQL String’ Category

SQL SERVER – Concat Function in SQL Server – SQL Concatenation

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL String, SQL Tips and Tricks, T SQL, Technology on November 25, 2010 | 17 Comments »

Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2″. I had great time delivering the session. During the session, we talked about SQL Server 2010 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though, SQL Server is now in moving [...]

Read Full Post »

SQL SERVER – Get Numeric Value From Alpha Numeric String – Get Numbers Only

Posted in Pinal Dave, SQL, SQL Authority, SQL Function, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL String, SQL Tips and Tricks, T SQL, Technology on September 25, 2010 | 5 Comments »

I have earlier wrote article about SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only and it was very handy tool for me. Recently blog reader and SQL Expert Christofer has left excellent improvement to this logic. Here is his contribution. He has provided Stored Procedure and [...]

Read Full Post »

SQL SERVER – Function to Retrieve First Word of Sentence – String Operation

Posted in SQL, SQL Authority, SQL Function, SQL Query, SQL Server, SQL String, SQL Tips and Tricks, T SQL, Technology on August 20, 2010 | 7 Comments »

I have sent of function library where I store all the UDF I have ever written. Recently I received email from my friend requesting if I have UDF which manipulate string and returns only very first word of the statement. Well, I realize that I do not have such a script at all. I found [...]

Read Full Post »

SQL SERVER – Finding the Occurrence of Character in String

Posted in Pinal Dave, SQL, SQL Authority, SQL Function, SQL Query, SQL Scripts, SQL Server, SQL String, SQL Tips and Tricks, T SQL, Technology on August 16, 2010 | 12 Comments »

This article is written in response to provide hint to TSQL Beginners Challenge 14. The challenge is about counting the number of occurrences of characters in the string. Here is quick method how you can count occurrence of character in any string. Here is quick example which provides you two different details. How many times [...]

Read Full Post »

SQLAuthority News – Converting a Delimited String of Values into Columns

Posted in Pinal Dave, SQL, SQL Authority, SQL Function, SQL Query, SQL Server, SQL String, SQL Tips and Tricks, SQL XML, SQLAuthority Website Review, T SQL, Technology on February 10, 2010 | 2 Comments »

This blog post is about two great bloggers and their excellent series of blog posts. It was quite unusual to see two bloggers posting articles that are supporting each other and constantly improving the articles to the next level. Two blogs which I am going to mention here are as follows: SELECT Blog FROM Brad.Schulz [...]

Read Full Post »

Older Posts »