Count All the row from All Table in a Database

SELECT

FROMsysobjects.Name, sysindexes.RowssysobjectsINNER JOIN sysindexesON sysobjects.id = sysindexes.idWHEREtype = 'U'
AND sysindexes.IndId < 2and sysindexes.Rows > 0ORDER BYsysobjects.Name

Use of Split Function in Sql Server

---For Example select dbo.SplitStr('1254,1254,1254,2154',',') 
 
 
CREATE FUNCTION dbo.SplitStr(@String varchar(8000), @Delimiter char(1))         
returns @temptable TABLE (items varchar(8000))         
as         
begin         
    declare @idx int         
    declare @slice varchar(8000)         
        
    select @idx = 1         
        if len(@String)<1 or @String is null  return        
        
    while @idx!= 0         
    begin         
        set @idx = charindex(@Delimiter,@String)         
        if @idx!=0         
            set @slice = left(@String,@idx - 1)         
        else         
            set @slice = @String         
            
        if(len(@slice)>0)    
            insert into @temptable(Items) values(@slice)         
   
        set @String = right(@String,len(@String) - @idx)         
        if len(@String) = 0 break         
    end     
return         
end   

Generating XML String by Sql query

Use this query for creating xml string by a single query 

" SELECT

* FROM  Tablename  FOR XML AUTO  "