node Archives - SQLServerGeeks

SQL Server / SQL Server Accidental DBA Series

Function to Convert Text String to Proper Case in SQL Server

October 9, 2014December 23, 2019 - by SQL Geek - Leave a Comment

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 String to Date in SQL Server

October 8, 2014December 23, 2019 - by SQL Geek - Leave a Comment

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 …

SQL function – convert list to table

May 3, 2014December 23, 2019 - by SQL Geek - 1 Comment

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 ( …