Interested to Buy Any Domain ? << Click Here >> for more details...
What are user defined datatypes and when you should go for
them?
- 1 Answers
- 8213 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 |
What is the use of tempdb? What values does it hold?
What is ddl command?
How to select all columns of all rows from a table with a select statement in ms sql server?
Explain filestream storage of sql server 2008?
Comment,Datatypes are unlimited
What is the maximum size of column in sql server?
What Are Three Rules to Use UNION IN SQL SERVER
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is nonclustered index with included columns ?
What are the dmvs?
how to give input dynamically to a insert statement in sqlserver
Define Unique Key?
-
Oracle (3253) - 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)
