DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Plz Help

  1. #1
    Join Date
    May 2006
    Posts
    11

    Plz Help

    i need porcdeure that do this

    1. select from table
    2. create dummy table
    3. update to dummy table
    4. if all ok give 0 if noe give 1

    all this in one script

    thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    write one then (much like your last request)

  3. #3
    Join Date
    Jun 2005
    Location
    London, UK
    Posts
    159
    It is generally a bad idea to make schema modifications within a stored procedure. Why would you need a "dummy table"? What if two sessions wanted to execute the procedure at the same time?

Posting Permissions

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


Click Here to Expand Forum to Full Width