Function to Convert Text String to Proper Case in SQL Server
Many a times need arises to convert a string into proper case specially the names. Let’s have a look at a SQL Server function to convert text string to proper case. …
Read MoreTag: XML
Function to Convert String to Date in SQL Server
The SQL Server has inbuilt function to convert string to date. It can be done using CAST/CONVERT as shown below DECLARE @stringdate varchar(100), @cast_dt datetime, @conver_dt datetime SET @stringdate=’09/25/2014′ SET @cast_dt=CAST(@stringdate …
Read MoreSQL function – convert list to table
Here is quick SQL function to convert list to table. — sql function to convert list to table CREATE FUNCTION fn_listtotable ( @list nvarchar(max), @delimeter nvarchar(100) ) RETURNS @split TABLE ( …
Read MoreHow to Handle Null Values in XML
Hello Folks, You might be wondering about how to handle NULLS if it’s a part of XML result set. Well, I have some keynotes about it, so please see it carefully: Till …
Read MoreXML Datatype in SQL Server- A small example
Dear All, XML data type was introduced in SQL Server 2005. This type allows you to store XML data up to 2 GB. Here is a small example of, pretty much …
Read More