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 |
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
How to delete duplicate rows in sql server?
Can I save my report as html, excel or word? : sql server management studio
Why main is user defined function?
What are the advantages of using stored procedures?
write down the code for "how we delete a table without using of Drop command " ?
7 Answers CarrizalSoft Technologies, Sonata,
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Explain user defined views?
What is Right Outer Join?
write the query for taking database restore in sql?
What is instead of trigger sql server?
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
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)