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.

How to get nth highest salary from employee table.

0 Answers  

---

How to get the query of a table in sql server?

0 Answers  

---

What is rank function?

0 Answers  

---

What is the purpose of a table?

0 Answers  

---

Which command is used for user defined error messages?

0 Answers  

---

What is the difference between a function and a trigger?

0 Answers  

---

What does nvl stand for?

0 Answers  

---

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

---

Difference between uniqe index and uniqe constraint?

0 Answers  

---

How do I get to sql server configuration manager?

0 Answers  

---

What do you understand by mirroring?

0 Answers  

---

Mention the differences between local and global temporary tables.

0 Answers  

---