overwriting arguments in t-sql functions

Question

I was playing around with some code and realized that it is possible to overwrite the argument to a t-sql function. i.e.,

create function someFn(@date date) as
begin
if @date is null set @date = getdate()

will set @date to be today's date if the argument was null.

This appears only to make any sense if t-sql is treating their arguments as references not values. I realized that I don't actually know what the t-sql rules are for cases like this and was hoping someone could elaborate what is going on here. (I don't ever recall seeing any value vs. reference discussion with respect to t-sql code for that matter actually..)

Joe Stefanelli · Accepted Answer · 2011-01-10 20:52:04Z

1

The @date you're working with here is local to your function. You'll change the value within the function but not affect the value in the calling code.

answered Jan 10, 2011 at 20:52

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TonyP · Accepted Answer · 2011-01-10 20:57:19Z

0

Function must be declare with a return value/type and last statment must be a return statement. If your last statment returns @date then Getdate() value will be returned.

answered Jan 10, 2011 at 20:57

TonyP

5,89314 gold badges64 silver badges101 bronze badges

Collectives™ on Stack Overflow

overwriting arguments in t-sql functions

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related