How many sql databases can you have on one server?

0 Answers  

---

How do you sort in sql?

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,

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

0 Answers  

---

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

---

what is 'mysqldump'? : Sql dba

0 Answers  

---

Its possible to add more than one primary key for the table

4 Answers  

---

Does sql profiler affect performance?

0 Answers  

---

Explain the select statement in sql?

0 Answers  

---

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

what are the limitations of identity column? : Transact sql

0 Answers  

---

What is an invalid partition table?

0 Answers  

---