Answer / manoj kaushik

/* Same as previous example, this time using a
** cursor. Each update commits as it is made.
*/
create procedure increase_price_cursor
as
declare @price money

/* declare a cursor for the select from titles */
declare curs cursor for
select price
from titles
for update of price

/* open the cursor */
open curs

/* fetch the first row */
fetch curs into @price

/* now loop, processing all the rows
** @@sqlstatus = 0 means successful fetch
** @@sqlstatus = 1 means error on previous fetch
** @@sqlstatus = 2 means end of result set reached
*/
while (@@sqlstatus != 2)
begin
/* check for errors */
if (@@sqlstatus = 1)
begin
print "Error in increase_price"
return
end

/* next adjust the price according to the
** criteria
*/
if @price > $60
select @price = @price * 1.05
else
if @price > $30 and @price <= $60
select @price = @price * 1.10
else
if @price <= $30
select @price = @price * 1.20

/* now, update the row */
update titles
set price = @price
where current of curs

/* fetch the next row */
fetch curs into @price
end

/* close the cursor and return */
close curs
return

What is exception? What are the types of exceptions?

0 Answers  

---

Who developed sql?

0 Answers  

---

What is the diffrence between IN and EXISTS.which one is faster.

3 Answers   Infogain,

---

What is trigger price?

0 Answers  

---

What is a constraint? Tell me about its various levels.

0 Answers  

---

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

---

What is sql comments?

0 Answers  

---

what are the different functions in sorting an array? : Sql dba

0 Answers  

---

Why truncate is used in sql?

0 Answers  

---

What is a behavioral trigger?

0 Answers  

---

Can we commit inside a trigger?

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---