Defaultgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
Can you explain/or show how to create a table to have the columns default to blank space instead NULL when there is no value. and the datatypes of the various columns could be decimal, float, char etc.
-- Anonymous, December 20, 2000
You can use Transact SQL to add a constraint such as:
ALTER TABLE [dbo].[TableName] WITH NOCHECK ADD CONSTRAINT [DF_TableName_ColumnName] DEFAULT ('') FOR [ColumnName]
I don't understand the second part of your question though. Numeric columns cannot be defaulted to blank.
Hope this helps,
-- Anonymous, December 23, 2000