What is user defined datatypes and when you should go for them?

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

How to test values returned by a subquery with the in operator?

0 Answers  

---

What program is used to store the data source file?

0 Answers  

---

Do you know what is a with(nolock)?

0 Answers  

---

What are four major operators that can be used to combine conditions on a where clause?

0 Answers  

---

Where do we use trace frag?

0 Answers  

---

What are the tool windows in sql server management studio? : sql server management studio

0 Answers  

---

What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,

---

What do you understand by a stored procedure?

0 Answers  

---

Is sql different from sql server?

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---