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.

Explain about Normalization?

0 Answers   Infosys,

---

Explain SELF JOIN ?

3 Answers   ADP,

---

What is logshipping and its purpose?

0 Answers  

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

---

---

How is sql used in sql server?

0 Answers  

---

What do you do in data exploration

0 Answers   EXL,

---

Can we use max in where clause?

0 Answers  

---

What is mapping schema?

0 Answers  

---

Explain different forms of normalization?

0 Answers  

---

How to drop an existing schema in ms sql server?

0 Answers  

---

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---