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 a subquery in a select query statement in ms sql server?

0 Answers  

---

What are the difference between “where” and “having” clause in sql server?

0 Answers  

---

Explain transaction isolation levels in sql server?

0 Answers  

---

How to assign null values to variables or columns?

0 Answers  

---

Can we call stored procedure in trigger?

0 Answers  

---

Define clusters?

0 Answers  

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

---

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

---

How to create indexed view?

0 Answers  

---

What do you mean by data integrity?

0 Answers  

---

What are the different types of cursor?

0 Answers   HCL,

---

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

---