i can get the default value of column_def using Stored procedure -
sp_columns tablename .
column_def returns the default value.
lets say 'abc' is set as default value of a nchar field.
the column_def shows (N'abc') as value.
If I set 10 as default value of an int column , the column_def shows ((10)) as value
i want to know exact default value.
are there some rules to intercept the exact value ?
