>I am having trouble assigning a default value to a user defined data type in code.
>I can create the default object using
>CREATE DEFAULT DEFAULTZERO as 0
>and I can create the datatype using
>CREATE TYPE Logical FROM bit NOT NULL
>but I can't seem to get the right binding syntax for assigning DefaultZero as the default object for Logical.
>I can do it manually through SQL Studio
>TIA
>Trevor
I found some suggestions on creating a default in the Help of create user-defined type.
http://msdn.microsoft.com/en-us/library/aa258258%28SQL.80%29.aspxI haven't checked if this is the way to go here, but it seems it is.
If it's not broken, fix it until it is.
My Blog