Calculate row length of table(s)

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

Create Procedure FindRowLength ( @TabName VarChar(100) = '' )
As
Begin
set nocount on
If @TabName = ''
Begin
	SELECT	o.name, Sum( C.length ) As rowLength from 
		sysobjects o 
		INNER JOIN
        	sysColumns C 
	ON 	o.id = C.id
	WHERE	(o.xtype = 'u') AND (o.type = 'u') 
	Group by o.name
	ORDER BY o.name
End
Else
Begin
	SELECT	o.name, Sum( C.length ) As rowLength from 
		sysobjects o 
		INNER JOIN
        	sysColumns C 
	ON 	o.id = C.id
	WHERE	(o.xtype = 'u') AND (o.type = 'u')  and o.name = @TabName
	Group by o.name
	ORDER BY o.name
End
End

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

execute FindRowLength