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 does it mean to manipulate data?

0 Answers  

---

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

0 Answers  

---

What is create statement?

0 Answers  

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  

---

What is the use of commit?

0 Answers  

---

---

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

---

Does the order of columns in update statements matter?

0 Answers  

---

What are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,

---

what kind of lan types do you know? : Sql server database administration

0 Answers  

---

What is 2nf normalization form?

0 Answers  

---

What are the authentication modes in sql server? How can it be changed?

0 Answers  

---

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

0 Answers  

---