forum.venkateswarlu.net
      Register      Login
SQL Server User Defined Data Type

1 replies to this topic

Sivaramakrishnan G #1
Member
14 Points
 Posted on 21 Nov 2013 07:12 PM IST

Dear All,
  In my Project I am going to use User Defined Data type for numeric fields (For Salary Columns).

DataType Name : SALARY
Size                  : NUMERIC(23,3).

Can any one tell me while creating the UDDT is it possible to defined Default Value for the same.For this SALARY UDDT i want default value is "0" (Zero).

Regards
Siva

 
SQL Server     745 views     Reply to this topic
Cherukuri Venkateswarlu #2
Member
140 Points
 Replied on 21 Nov 2013 08:20 PM IST
Hi Sivaramakrishnan,

Please refer below link. The below link will explain how to set default values for user defined data types.


Hope this will helps you.
 
Reply to this topic