Answer / gowrishankar

it is one of the standard suite of client tools that are
distributed with sqlserver 2000.
it can also use for trouble shooting purpose.

Answer / sunil mishra

SQL Profiler is a graphical tool that allows system
administrator to monitor events in an instance od MSSQL.
u can save and capture data about each events to a file

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

0 Answers  

---

What is pl sql script?

0 Answers  

---

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

What mean sql?

0 Answers  

---

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,

---

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

what is the difference between delete and truncate statement in sql? : Sql dba

0 Answers  

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

Difference between table function and pipelined function?

0 Answers  

---

What is a cursor ? Why Cursor is required ?

3 Answers  

---

Which is faster count (*) or count 1?

0 Answers  

---

what is indexing, searching and user interface?

1 Answers   HCL,

---