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.

What is the use of partition by in sql server?

0 Answers  

---

What is the difference between UNION and UNIONALL?

5 Answers   CarrizalSoft Technologies, CTS,

---

What is data source view or dsv? : sql server analysis services, ssas

0 Answers  

---

How to check if stored procedure is running in sql server?

0 Answers  

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,

---

What is self contained scalar sub query?

0 Answers  

---

what is a schema in sql server 2005? : Sql server database administration

0 Answers  

---

What is sql server programming?

0 Answers  

---

What is bulkcopy in sql?

0 Answers  

---

Give an example of why you would want to denormalize a database

0 Answers  

---

Tell me what is a linked server?

0 Answers  

---

How to set a database state to offline in ms sql server?

0 Answers  

---