Interested to Buy Any Domain ? << Click Here >> for more details...
What are user defined datatypes and when you should go for
them?
- 1 Answers
- 8157 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to use “drop” keyword in sql server and give an example?
Can a rule be bound to any column of any data type?
What is a sql join?
what are the Prerequisites for Replication?
How to name query output columns in ms sql server?
What is the difference between update lock and exclusive lock?
What is SCOPE_IDENTITY() in sql
could u plz explain about joins and views?
Explain aggregate functions?
What are the differences between triggers and stored procedures?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What are orphan records?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
