Answer / diyvasrajesh

SQL Loader is used to convert data from flat files to ORACLE
database...

how to replace double quotes by single quotes in sql server

2 Answers   CAC,

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

0 Answers  

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

What are partitioned views and distributed partitioned views?

0 Answers  

---

How to create a new schema in a database?

0 Answers  

---

how to give input dynamically to a insert statement in sqlserver

3 Answers   HCL,

---

What is pivot and unpivot?

0 Answers  

---

Write a query to find 5th highest amount paid from the customer table.

0 Answers  

---

What is a join in sql? What are the types of joins?

0 Answers  

---

What is acid db?

0 Answers  

---

How will you go about resolving deadlocks?

0 Answers  

---