Professional Web Applications Themes

T-SQL Function optional parameter ??? - Microsoft SQL / MS SQL Server

Though you can select from a view that includes a GetDate, something like: CREATE VIEW GetTheDate AS SELECT GETDATE() ThisIsTheDate From your function (without the default) you should be able to: SELECT ISNULL (dDateTo, ThisIsTheDate) MyDate From GetTheDate Russell Fields "Disap" <pl> wrote in message news:google.com... ...

Sponsored Links
  1. #1

    Default Re: T-SQL Function optional parameter ???

    Though you can select from a view that includes a GetDate, something like:

    CREATE VIEW GetTheDate
    AS
    SELECT GETDATE() ThisIsTheDate

    From your function (without the default) you should be able to:

    SELECT ISNULL (dDateTo, ThisIsTheDate) MyDate From GetTheDate

    Russell Fields

    "Disap" <pl> wrote in message
    news:google.com... 


    Sponsored Links
    Russell Guest

  2. #2

    Default T-SQL Function optional parameter ???

    When you call a function you must include all parameters.
    If you want to use the defined default, pass in the
    keyword DEFAULT, e.g.,

    SELECT * FROM fmMyFunction(DEFAULT)

    HTH
    Vern
     
    the procedure 
    dose not work : 
    [ = default 
    Vern Guest

  3. #3

    Default Re: T-SQL Function optional parameter ???

    Thanks evrybody for reples.
    It is not as simple as I thought
    I resigned optional parameter in my function.

    Best Regards
    Disap
    xisiek Guest

Similar Threads

  1. Replies: 0
    Last Post: October 27th, 01:12 AM
  2. Why generate minOccurs='0' while the parameter is not optional?
    By Alan Chen in forum ASP.NET Web Services
    Replies: 1
    Last Post: September 11th, 10:24 AM
  3. Error in proxy when calling Web service with optional parameter
    By John Harkin in forum ASP.NET Web Services
    Replies: 0
    Last Post: April 13th, 01:23 PM
  4. #26309 [NEW]: imageftbbox() requires the optional parameter
    By kputnam at putnamcabinets dot com in forum PHP Development
    Replies: 0
    Last Post: November 19th, 06:05 AM
  5. Function definition with optional parameters?
    By Phester in forum PHP Development
    Replies: 4
    Last Post: September 28th, 09:27 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