{"id":689,"date":"2017-11-27T12:42:45","date_gmt":"2017-11-27T12:42:45","guid":{"rendered":"http:\/\/jonescarvalho.com\/Blog\/?p=689"},"modified":"2020-05-13T20:46:58","modified_gmt":"2020-05-13T23:46:58","slug":"funcao-split-string-sql","status":"publish","type":"post","link":"https:\/\/jonescarvalho.com\/Blog\/?p=689","title":{"rendered":"Fun\u00e7\u00e3o Split String SQL"},"content":{"rendered":"<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SET ANSI_NULLS ON\nGO\nSET QUOTED_IDENTIFIER ON\nGO\n\nCREATE FUNCTION [dbo].[fnSplitString]\n(\n@string NVARCHAR(MAX),\n@delimiter CHAR(1)\n)\nRETURNS @output TABLE(splitdata NVARCHAR(MAX)\n)\nBEGIN\nDECLARE @start INT, @end INT\nSELECT @start = 1, @end = CHARINDEX(@delimiter, @string)\nWHILE @start &lt; LEN(@string) + 1 BEGIN\nIF @end = 0\nSET @end = LEN(@string) + 1\n\nINSERT INTO @output (splitdata)\nVALUES(SUBSTRING(@string, @start, @end - @start))\nSET @start = @end + 1\nSET @end = CHARINDEX(@delimiter, @string, @start)\n\nEND\nRETURN\nEND<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[fnSplitString] ( @string [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[48,30],"class_list":["post-689","post","type-post","status-publish","format-standard","hentry","category-dicas","tag-funcoes","tag-sql"],"_links":{"self":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts\/689"}],"collection":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=689"}],"version-history":[{"count":6,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts\/689\/revisions"}],"predecessor-version":[{"id":830,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts\/689\/revisions\/830"}],"wp:attachment":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}