Posts

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

    Insert Into @RtnValue (dat…

Submit Blogger Sitemap to WebMaster Tools

Image
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:
                    /atom.xml?redirect=false

Also, enter this sitemao:
                    /feeds/posts/default?=rss

These two sitemaps will make sure your blog will be indexed correctly.
Have fun and keep up the good work,
Elad Shalom,
CTO at ITweetLive.com