• This query returns only 8000 single ones in the query result message tab like (11111...), but it should be display 8005 single ones in that message tab not count.

    You wont be able to display more than 8000 characters with PRINT no matter how much you want to

    read the PRINT specs here , max is 8000 non unicode chars

    http://msdn.microsoft.com/en-us/library/ms176047.aspx

    Also this is a strange request, why would you want to do this?