Interested to Buy Any Domain ? << Click Here >> for more details...
What are user defined datatypes and when you should go for
them?
- 1 Answers
- 8050 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 triggers and its types?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
How many columns can exist together per table?
What encryption security is available in sql azure?
What is sql server 2000 work load governor?
What are the difference between “where” and “having” clause in sql server?
List the ways in which dynamic sql can be executed?
What is difference between cte and view?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
How to choose all records from the table?
When is update_statistics command used?
How many non clustered indexes there can be on table ?
What are translations and its use? : sql server analysis services, ssas
How to get the definition of a view out of the sql server?
Where is my database stored on the hard disk in ms sql server?
