How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

0 Answers  

---

What happens if null values are involved in datetime operations?

0 Answers  

---

What is a transactions?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

---

What are the various Isolation levels?

2 Answers   HP,

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

What is 'Join' and explain its various types.

0 Answers   Genpact,

---

How do you find the number of rows in a table?

7 Answers  

---

Characterize join and name diverse sorts of joins?

0 Answers  

---

Tell me what are the advantages of using stored procedures?

0 Answers  

---

How to receive returning result from a query?

0 Answers  

---