Answer Posted / 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.

Can we perform backup restore operation on tempdb? : sql server database administration

949

---

Can we use pragma autonomous_transaction in trigger?

916

---

Explain syntax for viewing trigger?

890

---

What is the purpose of grouping data in a report?

915

---

What are the two modes of authentication in sql server?

988

---

How to list all tables in the database using odbc_tables()?

991

---

What are the features of Embedded SQL

1079

---

What are the differences between local and global temporary tables?

1021

---

How to download and install microsoft .net framework version 2.0?

1108

---

what information is maintained within the msdb database? : Sql server administration

920

---

How to list all objects in a given schema?

995

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1077

---

What is a result set object returned by mssql_query()?

1083

---

How many categories of data types used by sql server?

976

---

What happens to a statement batch if there is a compilation error?

906

---