What are user defined datatypes and when you should go for
them?
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 stored by the master? : sql server database administration
I have to display ten columns values from diffrent ten tables. how many joins are require?
10 Answers CarrizalSoft Technologies, HCL,
How to create a login account in ms sql server to access the database engine using "create login" statements?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What are the recovery models in sql server 2000?
What is difference between oltp and olap?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation
How to create an inline table-valued function?
How to insert a new row into a table with "insert into" statements in ms sql server?
How can you find out how many rows returned in a cursor?
What is equi join with example?
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)