Showing posts from September 25, 2011

Split String in SQL Server

Split String in SQL Server. NVARCHAR and VARCHAR Split in MS SQL. For all of you there who wishes to preform a simple "split" on a varchar on nvarchar input in ms sql (sql server) this is for you: Basically, this post's gonna contain a Create Function Script which you will to execute in your server.  It will also contain the simplest way to use it. There will be more examples in a different post I'll upload soon... CREATE FUNCTION dbo.Split (     @RowData nvarchar(2000),     @SplitOn nvarchar(5) )  RETURNS @RtnValue table (     Id int identity(1,1),     Data nvarchar(100) ) AS  BEGIN     Declare @Cnt int     Set @Cnt = 1     While (Charindex(@SplitOn,@RowData)>0)     Begin         Insert Into @RtnValue (data)         Select             Data = ltrim(rtrim(Substring(@RowData,1,Charindex(@SplitOn,@RowData)-1)))         Set @RowData = Substring(@RowData,Charindex(@SplitOn,@RowData)+1,len(@RowData))         Set @Cnt = @Cnt + 1     End  

Submit Blogger Sitemap to WebMaster Tools

Submit Blogger Sitemap to Webmaster Tools. Submit Blogger Sitemap to Google Webmaster Tools. Atom.XML Error in Google Webmaster Tools. Hey there. Couple of hours ago I entered my Google Webmaster Tool account only to find out that my sitemap hasn't been indexed lately. After a click on the link, I found out that /atom.xml has an automatic redirect, which doesn't allow the webmaster tool to index it correctly. The fix is quite simple though. remove your current sitemap and replace it with this link:                     /at om. xml ?re dir ect =fa lse Also, enter this sitemao:                     /fe eds /po sts /de fau lt? =rs s     These two sitemaps will make sure your blog will be indexed correctly.   Have fun and keep up the good work, Elad Shalom, CTO at