Custom Function string_split for SQL Server 2008R2 (T-SQL split string)

For Those who have problem using  string_split function in SQL Server 2008R2

CREATE FUNCTION dbo.string_split
(
    @stringToSplit VARCHAR(MAX),
    @separator VARCHAR(MAX)
)

RETURNS

  @returnList TABLE ([value] [nvarchar] (500))

AS

BEGIN

 DECLARE @name NVARCHAR(255)
 DECLARE @pos INT

 WHILE CHARINDEX(@separator, @stringToSplit) > 0
 BEGIN
  SELECT @pos  = CHARINDEX(@separator, @stringToSplit) 
  SELECT @name = SUBSTRING(@stringToSplit, 1, @pos-1)

  INSERT INTO @returnList
  SELECT @name

  SELECT @stringToSplit = SUBSTRING(@stringToSplit, @pos+1, LEN(@stringToSplit)-@pos)
 END

 INSERT INTO @returnList
 SELECT @stringToSplit

 RETURN
END

Comments

Post a Comment

Popular posts from this blog

Top 5 AI Tools Every Developer Should Use to Boost Coding Efficiency

Artificial Intelligence (AI) is transforming the world of software development, making it faster and more efficient. For developers, AI tools can enhance productivity, reduce errors, and optimize the coding process. From intelligent code suggestions to debugging assistance, these tools are changing the way developers work. In this article, we will explore the top five AI tools that every developer should use to boost coding efficiency.   Why AI Tools Are Essential for Developers The complexity of modern software projects means developers often face tight deadlines, complicated codebases, and constant updates. This is where AI tools come in. They help automate repetitive tasks, improve accuracy, and provide intelligent insights that can significantly speed up development time.  Whether you’re a seasoned developer or just starting, incorporating AI tools into your workflow can lead to more efficient and high-quality code.    1. GitHub Copilot   ...
Read more

How To Generate Random Dates Between Two Date Range in SQL Server

Those who wants to generate random dates between two date ranges in SQL Server can use the following query: DECLARE @FromDate DATETIME = DATEADD(DAY, -2, '2011-01-01') DECLARE @ToDate   DATETIME = DATEADD(DAY, -1, '2017-01-01') DECLARE @Seconds INT = DATEDIFF(SECOND, @FromDate, @ToDate) DECLARE @Random INT = ROUND(((@Seconds-1) * RAND()), 0) DECLARE @Milliseconds INT = ROUND((999 * RAND()), 0) SELECT DATEADD(MILLISECOND, @Milliseconds, DATEADD(SECOND, @Random, @FromDate)) Hope it works for you!
Read more

Find the number of columns in a table

Though its a rare situation when we need to know the number of columns in a table. You can get the number of columns information for a particular table by running the following query on SQL Server SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_catalog = ' Your_Database_Name '  AND table_name = ' Your_Table_Name ' Good luck!
Read more