Answer / naresh

DTS (Data Transformation Services) allows you to get stuff
in and out of SQL Server and between any ODBC and OLE DB
data source. That includes DB2, Access, Excel and Text, as
well as Oracle, MySQL, PostgresSQL and even SQLLite. -in
fact, anything with an ODBC driver. Not only does it do the
transfer but it allows you to fill in missing data, do
column mappings and so on. In other words, you can fiddle
with the data as it passes through.

When would you prefer to have a minimum number of indexes?

0 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  

---

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

---

What is difference between order by and group by?

0 Answers  

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

---

What is the sql server 2000 version number?

0 Answers  

---

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

What is query cost in sql server?

0 Answers  

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

Define normalisation?

0 Answers  

---