Interested to Buy Any Domain ? << Click Here >> for more details...
What are user defined datatypes and when you should go for
them?
- 1 Answers
- 8130 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 to rebuild master databse?
How you can get the list of largest tables in a database?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What happens if strings are casted into wrong code pages in ms sql server?
Explain the concepts and capabilities of sql server?
What is user defined stored procedures?
What purpose does the model database server?
What is sqlservr.exe - process - sql server (sqlex?press)?
what is the sql equivaent of the dataset relation object ?
What is tcl in sql server?
What are different replication agents and what's their purpose? : sql server replication
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? : Sql server administration
what is nonclustered index
How to create function with parameter in sql server?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
