DCSIMG
T-SQL,LEN - Itai Goldstein

Browse by Tags

All Tags » T-SQL » LEN (RSS)

T-SQL Split function

During one of the projects I worked on, I had to parse a text which was passed from the application in my T-SQL code. I found that T-SQL had no built-in string system function for this operation, which I find rather useful, especially in cases you need to perform some batch based operations (which helps accelerate your application performance by reducing round trips to the DB). So I came up with the following solution: CREATE FUNCTION [dbo].[Split] ( @RowData NVARCHAR( MAX ), @Delimeter NVARCHAR...