What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

How to get last system shutdown time in Sql server when restarted system?

1 Answers  

---

How to delete an existing database user?

0 Answers  

---

Detail about query optimizer?

0 Answers  

---

---

Which databases are part of SQL server default installation? Explain the usage of each?

2 Answers   Accenture,

---

How do you make a trace?

0 Answers  

---

How to download microsoft sql server 2005 express edition?

0 Answers  

---

What is difference between delete and truncate commands?

0 Answers  

---

logshipping is Any difference 2000 and 2005?

2 Answers  

---

What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,

---

How to automatically create a log when an exception is being received into SQL Server?

0 Answers   Cap Gemini,

---