Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2006
    Posts
    2

    Question Unanswered: Stored Procedure

    Hello All,

    I've never worked in ms SQL and come from a programming background using transact SQL in C/C++.

    I used to work with SQL in Ingress and would be able to update a number of records based on an SQL statement. For example:

    update applications
    set App_name = 'ask'
    where App_Name Like 'asm%'

    In MS SQL I can only update one record at a time wich is very cumbersom and will take forever. What is the best way to accomplish this?

    Thanks for any help/ suggestions

    john

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by John_OC
    Hello All,

    I've never worked in ms SQL and come from a programming background using transact SQL in C/C++.

    I used to work with SQL in Ingress and would be able to update a number of records based on an SQL statement. For example:

    update applications
    set App_name = 'ask'
    where App_Name Like 'asm%'

    In MS SQL I can only update one record at a time wich is very cumbersom and will take forever. What is the best way to accomplish this?

    Thanks for any help/ suggestions

    john
    Huh?

    SQL is a set based language...what are you trying to accomplish?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2006
    Posts
    2
    I thought I stated what I was trying to do. I would like to update a number of records.

    For example:

    update applications
    set App_name = 'ask'
    where App_Name Like 'as%'

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The code sample you gave for Ingress will work perfectly in MSSQL.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by John_OC
    In MS SQL I can only update one record at a time wich is very cumbersom and will take forever.
    Who fed you that poppycock?

    I'm not aware of any standard SQL feature that Ingress supports that Microsoft SQL hasn't supported since version 7.0. Your SQL example should work just fine.

    -PatP

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by Pat Phelan
    Who fed you that poppycock?
    Mmmmm....yummy!
    http://www.donogh.com/cooking/holiday/poppycoc.shtml
    Can I get some too?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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