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 More