What are user defined datatypes and when you should go for
them?
- 1 Answers
- 7698 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
What is the definition for sql server 2000?
How to use linked server?
Explain the truncate command?
How to update muliple row in single query?
Where can you find the error log information? : sql server database administration
How to check status of stored procedure in sql server?
What is candidate key with example?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is a covering index?
Can two tables share a primary key?
What is the concept of optimization?
What are the differences between having and where clause.
Write a query to find 5th highest amount paid from the customer table.
What are filegroups in sql server?
What are different types of roles provided by ssrs?
