Interested to Buy Any Domain ? << Click Here >> for more details...
What are user defined datatypes and when you should go for
them?
- 1 Answers
- 8142 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
How many types of triggers in sql server?
Is sql different from sql server?
Explain the truncate command? : SQL Server Architecture
What is a non equi join?
What happens when converting big values to integers?
What is the difference between push and pull subscription? : sql server replication
Explain what is the difference between a local and a global temporary table?
explain the storage models of olap? : Sql server database administration
Can you import Microsoft Excel data to SSRS?
Do you know the isolation level that sql server support?
Do you know nested transaction?
How network traffic be reduced by using the stored procedure?
How to insert data with null values?
what is the difference between count(*) and count(1) ?
Can foreign key be duplicate?
