Interested to Buy Any Domain ? << Click Here >> for more details...
What are user defined datatypes and when you should go for
them?
- 1 Answers
- 8214 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
User defined datatypes let you extend the base SQL Server
datatypes by providing a descriptive name, and format to
the database. Take for example, in your database, there is
a column called Flight_Num which appears in many tables. In
all these tables it should be varchar(8).
In this case you could create a user defined datatype
called Flight_num_type of varchar(8) and use it across all
your tables.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
define and explain the differences between clustered and non-clustered indexes.
What is dml command?
What is function of CUBE ?
your distribution database is full what will u do
Explain the difference between HTTP and HTTPS in database?
How to connect to a sql server using odbc_connect()?
How to count groups returned with the group by clause in ms sql server?
Do you know what is a linked server in sql server?
What is a trace frag?
Tell me what are cursors and when they are useful?
Do you know what is difference between stored procedure and user defined function?
What is the difference between getdate and sysdatetime?
How do you create a data source?
What is a subquery in a select query statement in ms sql server?
How column data types are determined in a view?
