SQL Server Education (by the geeks, for the geeks)
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. …
Function to Convert Text String to Proper Case in SQL Server Read MoreThe 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 …
Function to Convert String to Date in SQL Server Read MoreHere 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 ( …
SQL function – convert list to table Read MoreHello 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 …
How to Handle Null Values in XML Read MoreDear 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 …
XML Datatype in SQL Server- A small example Read More