ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
What are user defined datatypes and when you should go for 
them?
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are user defined datatypes and when you should go for them?
Answer
# 1		 
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 ?    4 Yes 1 No
Swapna
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What are the types of backup and tell me the difference between full and differential backup? TCS3
Difference between server.transfer and server.execute method?  1
What is normalization and what are the different forms of normalizations?  1
can any one please send sql quries most used in applications.  1
Can we rewrite subqueries into simple select statements or with joins? Example? ASD1
Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number. Value-Labs4
What is cursor ? And what is difference between Trigger ? HCL1
From where can you change the default port?  3
Write a query to delete duplicate records in SQL SERVER Infosys19
When you first load SQL SERVER you will startup with what all databases? CompuSol3
What is Peer to peer Replication? HCL1
What is Deadlock? Satyam3
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh  3
How do you find the error, how can you know the number of rows effected by last SQL statement?  1
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.  1
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no. iFlex2
MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE IBM1
What are the advantages of using views. Why do we need views when we have SPs? 247Customer3
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply Covansys1
What does the INSTEAD OF trigger do?  3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com