T-SQL

Using SQL to get the number of occurrences of a character in a string in SQL Server

This SQL Snippet can be used to get the count of a single character, or an entire phrase, in a string.  We have a seperate post for doing the same thing in Oracle. Assume you have the string “a,b,c,d,e” and you want the count of commas (“,”) contained in that string.  Just use the SQL below:…

SQL Azure

The Windows Azure platform offers the optional SQL Azure database as a supplement to the rudimentary data storage provided by the Storage AppFabric.  Unlike the storage appFabric, SQL Azure is a cloud-based relational database that is an extension of Microsoft SQL Server.  This multi-tenant, highly scalable database runs in the Azure cloud.  This cloud-based database supports the…