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 meant by datasource?

0 Answers  

---

what is integrated security (SSPI). why we use in the connection string?

2 Answers  

---

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

---

what is dbcc? : Sql server database administration

0 Answers  

---

Determine when to use stored procedure to complete sql server tasks?

0 Answers  

---

How many index keys possible for a table

6 Answers  

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

Can you use order by when defining a view?

0 Answers  

---

What are the differences between user defined functions and stored procedures?

0 Answers  

---

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

7 Answers   ADP, Satyam, Tech Mahindra,

---

Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,

---