Professional Web Applications Themes

Funtions With Multiple Parameters - Microsoft SQL / MS SQL Server

Hi , what wrong do i m doing in this Create Function CREATE FUNCTION getPriceByEffective (EffectiveDate varchar(10), CurrentPrice money, NewPrice money) RETURNS money AS BEGIN DECLARE Price Money IF EffectiveDate IS NULL THEN SET Price = CurrentPrice ELSE SET Price = NewPrice RETURN (Price) END i am getting Error while creating it. Unexcpected Function Type Any Help will be great Thanks, Brij...

  1. #1

    Default Funtions With Multiple Parameters

    Hi ,

    what wrong do i m doing in this Create Function


    CREATE FUNCTION getPriceByEffective (EffectiveDate varchar(10),
    CurrentPrice money, NewPrice money)
    RETURNS money
    AS
    BEGIN
    DECLARE Price Money
    IF EffectiveDate IS NULL THEN
    SET Price = CurrentPrice
    ELSE
    SET Price = NewPrice

    RETURN (Price)

    END


    i am getting Error while creating it.
    Unexcpected Function Type

    Any Help will be great

    Thanks,

    Brij


    Brij Guest

  2. #2

    Default Re: Funtions With Multiple Parameters

    First, there is no 'THEN' clause for IF.. ELSE constructs. Removing it will
    rectify the syntax problem.

    Also, use a CASE expression instead of UDFs for such trivial
    functionalities.

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Guest

  3. #3

    Default Re: Funtions With Multiple Parameters

    Well Thanks but i got figured out ..
    but habbit of using VB so also i type then after if

    brij

    "Anith Sen" <com> wrote in message
    news:phx.gbl... 
    will 


    Brij Guest

Similar Threads

  1. OCR funtions in Acrobat 7 SDK
    By Geoff_Ch@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 1
    Last Post: August 7th, 07:13 PM
  2. Searching with multiple search parameters PHP
    By vaene in forum Dreamweaver AppDev
    Replies: 1
    Last Post: April 4th, 08:21 AM
  3. ASP - Multiple URL Parameters ?? Howto
    By Mattboy_Slim in forum Dreamweaver AppDev
    Replies: 1
    Last Post: March 5th, 10:04 PM
  4. Returning multiple parameters from .Net Webservic
    By Aalok in forum Macromedia Flash Actionscript
    Replies: 1
    Last Post: March 2nd, 10:49 PM
  5. Multiple Parameters With Hyperlink in DataGrid
    By eRic in forum ASP.NET Building Controls
    Replies: 5
    Last Post: July 19th, 09:19 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