Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    2

    Question Unanswered: Stored Procedures

    Greetings

    I am new to Stored procedures and need help.

    I have to read data in a table, modify each row then write it to another table.

    Can you please help me with the syntax. What I have is like this.

    Create proc updaterows
    (@name varchar (10),
    @lname varchar (20),
    @address varchar (20))
    as
    select * from table1
    where fname = @name
    lastname = @lname
    address = @address


    Please assist!

  2. #2
    Join Date
    Sep 2003
    Posts
    2
    If you know something called curson then you can very well use this to solve ur purpose.

  3. #3
    Join Date
    Jun 2003
    Posts
    15
    How about a little more info. What exactly are you updating? What is the criteria?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •