To the best of my knowledge there is nowhere that you can tell SQL Server that all integers should default to zero or characters to spaces. SQL Server only has two ways to set defaults and both are at the column level.

-Mike