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.

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

What is the difference between indexing and hashing?

0 Answers  

---

Is mysql better than sql server?

0 Answers  

---

System variable and temporary variables

0 Answers   Wipro,

---

what is sql server? : Sql server database administration

0 Answers  

---

---

What is row by row processing ?

2 Answers  

---

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

---

What do you understand by coalesce in sql server?

0 Answers  

---

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

---

How do I create a stored procedure in dbml?

0 Answers  

---

Explain how to maintain a fill factor in existing indexes?

0 Answers  

---

How can we write or define DDL statements in Sql server and DML statements?

3 Answers  

---