CREATE FUNCTION [dbo].[fnSplit](
@sInputList VARCHAR(8000) -- List of delimited items
, @sDelimiter
VARCHAR(8000) = ',' -- delimiter...
UDF For Splitting Comma Seperated Values
Monday, 5 October 2015
Widgets
Social Links
Search
Popular Posts
-
SQL commands are a set of instructions that are used to interact with the database like Sql Server, MySql, Oracle etc. SQL commands are re...
-
Stops the message that shows the count of the number of rows affected by a Transact-SQL statement or stored procedure from being returned a...
-
S ql joins are used to fetch/retrieve data from two or more data tables, based on a join condition. A join condition is... -
CHARINDEX - Searches an expression for another expression and returns its starting position if found. DECLARE @FullName VARCHAR ( 100 )...
-
Introduction Some time some duplicate data may inserted in the SQL table. But its harmful for you and your application too. So how to re... -
Introduction In this article I describe schemas in SQL Server 2012. A schema is like a container that contains database objects like tables... -
CREATE FUNCTION [dbo] . [fnSplit] ( @sInputList VARCHAR ( 8000 ) -- List of delimited items , @sDelimiter VARCHAR ( 8...
About Me
- Suraj Kumar Maddheshiya
- Myself Suraj Experiencing with Microsoft Technologies.