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.

Normalization and denormalization

3 Answers   Wipro,

---

What is fill factor and pad index?

0 Answers  

---

What security features are available for stored procedure?

0 Answers  

---

please differentiate between delete and truncate?

0 Answers  

---

How do I completely remove sql server instance?

0 Answers  

---

---

How can i Relate Tables in SSIS

0 Answers   HCL,

---

How to find the date and time of last updated table?

3 Answers  

---

Describe the left outer join & right outer join. : sql server database administration

0 Answers  

---

What are the OS services that the SQL Server installation adds?

3 Answers  

---

Explain what is the difference between a local and a global temporary table?

0 Answers  

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---

What are the differences between char and varchar in ms sql server?

0 Answers  

---