This code shows how to split string in sql
Declare @products varchar(200) = '1|20|3|343|44|6|8765' Declare @individual varchar(20) = null WHILE LEN(@products) > 0 BEGIN IF PATINDEX('%|%', @products) > 0 BEGIN SET @individual = SUBSTRING(@products, 0, PATINDEX('%|%', @products)) SELECT @individual SET @products = SUBSTRING(@products, LEN(@individual '|') 1, LEN(@products)) END ELSE BEGIN SET @individual = @products SET @products = NULL SELECT @individual END END
Are you sure you want to delete this post ?
If you want to search in all codes; just enter keywords and press enter.
If you want to search in your codes; include "in my codes" or "inmycodes" with your keywords.
If you want to search in questions; include "in questions" or "inquestions" with your keywords.
If you want to search in blogs; include "in blogs" or "inblogs" with your keywords.
If you want to search in c# codes; include "in c#" or "inc#" with your keywords.
If you want to search in javascript codes; include "in javascript" or "injavascript" with your keywords.
you can search in specific programming language using this search pattern.
Comments