Professional Web Applications Themes

Simulated Function in SQL 7.0 - Microsoft SQL / MS SQL Server

Hello, What is the best way to simulate a function in SQL 7.0? The function I have in mind would return a scalar value based on some input parameters. I would like to call the function from within another SQL statement. Thanks, Dan...

  1. #1

    Default Simulated Function in SQL 7.0

    Hello,

    What is the best way to simulate a function in SQL 7.0? The function I have
    in mind would return a scalar value based on some input parameters. I would
    like to call the function from within another SQL statement.

    Thanks,
    Dan


    solex Guest

  2. #2

    Default Re: Simulated Function in SQL 7.0

    Mohanjit,

    Thanks for the quick response, but I should have been clearer in my need.
    Basically I want to write a function that will format an address and be able
    to include the function call in a batch update as in:

    UPDATE Contacts
    SET address = FormatAddress(g.Line1, g.Line2, g.City, g.State, g.Zip,
    g.Country)
    FROM Contacts c, GContacts g
    WHERE c.ContactID = g.ContactID

    "Mohanjit" <uc.edu> wrote in message
    news:phx.gbl... 
    > have 
    > would 
    >
    >[/ref]


    solex Guest

  3. #3

    Default Re: Simulated Function in SQL 7.0

    >> I want to write a function that will format an address and be able to
    include the function call in a batch update <<

    If you mean format an address for output or display, you are supposed to
    be doing that in the front end, not the database. That is the whole
    idea of a client/server architecture.

    If you mean scrub address data for entry into the database, then I'd get
    a commercial mailing product that will put them in to standard USPS
    format. It is harder than it looks!

    --CELKO--
    ===========================
    Please post DDL, so that people do not have to guess what the keys,
    constraints, Declarative Referential Integrity, datatypes, etc. in your
    schema are.

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Joe Guest

Similar Threads

  1. Simulated Live with OD file
    By so_and_so in forum Macromedia Flash Flashcom
    Replies: 4
    Last Post: November 15th, 03:19 PM
  2. Simulated Live Broadcast
    By mongosit in forum Macromedia Flash Flashcom
    Replies: 2
    Last Post: May 14th, 06:56 PM
  3. Replies: 5
    Last Post: June 27th, 02:12 AM
  4. Simulated back button ....
    By Nancy Gill in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: February 22nd, 06:09 PM
  5. business plan or simulated enterprise
    By HI-Lab * the Social Technology in forum PHP Development
    Replies: 0
    Last Post: November 8th, 01:29 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139