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.

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

---

Tell me what is the difference between locking and multi-versioning?

0 Answers  

---

Can we write a distributed query and get some data which is located on other server and oracle database?

0 Answers  

---

Is it possible to have clustered index on separate drive from original table location?

0 Answers  

---

What is data compression?

0 Answers  

---

---

Do you know what are the steps to process a single select statement?

0 Answers  

---

Is sql server difficult to learn?

0 Answers  

---

What is de-normalization in sql database administration? Give examples?

0 Answers  

---

Explain the steps to use transact-sql cursor?

0 Answers  

---

What is deploy, process and build? : sql server analysis services, ssas

0 Answers  

---

how to connect sybase to sql server 2005?.

1 Answers   ABC,

---

How to provide default values to stored procedure parameters?

0 Answers  

---