Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #2238

Re: Parameters with default values in functions

Show all headers | View raw

Erland Sommarskog:

> I'm about to say that I don't even want to talk about
> this, because it is so stupid. That is, you must supply
> the DEFAULT keyword explicitly:
>
>   SELECT * FROM dbo.test(DEFAULT)
>

This is just... terrible.

> Which of course defies quite much of the idea with a
> default parameter when you want to add a new parameter to
> an existing function.
>
> Here is a feedback item you can vote for:
> https://feedback.azure.com/d365community/idea/95dbf609-5a25-ec11-b6e6-000d3a4f0da0

Thanks, I have voted and added a comment.  I wonder why MS
have decided to deny me the basic politeness of showing my
name, and to disaply "Community user" instead...

-- 
()  ascii ribbon campaign -- against html e-mail
/\  www.asciiribbon.org   -- against proprietary attachments

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Parameters with default values in functions Anton Shepelev <anton.txt@g{oogle}mail.com> - 2024-03-01 13:53 +0300
  Re: Parameters with default values in functions Erland Sommarskog <esquel@sommarskog.se> - 2024-03-01 23:18 +0100
    Re: Parameters with default values in functions Anton Shepelev <anton.txt@g{oogle}mail.com> - 2024-03-05 11:36 +0300
      Re: Parameters with default values in functions Anton Shepelev <anton.txt@g{oogle}mail.com> - 2024-03-05 11:39 +0300

csiph-web