Database

tr_thorn wrote:

how can i restore database to exists database.?

INSERT INTO myTable (myCondition1, myValue1, myOtherValue, myValue) VALUES ('...', 1, 2, 'F')

UPDATE myTable mt
SET myValue = 'P'
WHERE myCondition1 = 'Hello' AND myValue1 > 30 AND myOtherValue >
(Select SUM(oValue) FROM otherTable ot WHERE mt.PrimaryKey = ot.ForeignKey)

declare c1 cursor for
  select field1, field2, etc
  from YourTable
  for update of MyFlag
open c1
fetch c1 into @Field1, @Field2, @Etc
while (@@FETCH_STATUS <> 0) begin
  set @MyFlag = 'P'

  --Do business logic checks here - if error then set @MyFlag to 'F'.

  update YourTable set MyFlag = @MyFlag
    where current of c1

  fetch c1 into @Field1, @Field2, @Etc
end
close c1
deallocate c1

prithaa wrote:

What must be the problem?

CREATE PROCEDURE tryproc 
AS
DECLARE @first INT
SET @first = ( SELECT SUM(t) AS first 
             FROM demand 
             WHERE product = 'LPG' 
             AND LOCATION = 'Mumbai' )
CREATE TABLE abc (demandsum INT)
INSERT INTO abc (demandsum) VALUES (@first)

INSERT INTO pic_newsletter_email_addr (column2) VALUES ('foo@foo.com');