Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What are user defined datatypes and when you should go for
them?



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

Post New Answer

More SQL Server Interview Questions

What stored by the master? : sql server database administration

0 Answers  


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?

0 Answers  


what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  


What are the recovery models in sql server 2000?

0 Answers  


What is difference between oltp and olap?

0 Answers  


How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  


Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  


How to create an inline table-valued function?

0 Answers  


How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  


How can you find out how many rows returned in a cursor?

0 Answers  


What is equi join with example?

0 Answers  


Categories