Answer / guest

SQL SERVER - is for running the databases SQL AGENT - is for
automation such as Jobs, DB Maintanance, Backups DTC - Is
for linking and connecting to other SQL Servers

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

---

What is a non equi join?

0 Answers  

---

What is a Trace frag?Where can we use this?

1 Answers  

---

How can a database be repaired?

0 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

---

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

2 Answers  

---

Explain how to integrate the ssrs reports in application?

0 Answers  

---

What is trigger and different types of Triggers?

0 Answers   QuestPond,

---

what is checksum in sql server.........???

0 Answers   TCS,

---

How to encrypt data between dialogs?

0 Answers  

---

What is the difference between cartesian product and cross join?

0 Answers  

---

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

---