FLX SQL

Blog Post

On Session Evaluations

As PASS Summit approaches this week, I’m re-reviewing my evaluations from SQL Saturday Boston and I’d like to give feedback about feedback.
Why Feedback? Both speakers and event organizers depend...

2023-11-12

6 reads

Blog Post

Summit 2023 Is Nearly Here!

All week, my phone has been reminding me (via photo memories) of the amazing experience I had at PASS Summit 2017. This can mean only one thing - PASS...

2023-11-10 (first published: )

106 reads

Blog Post

SQL Saturday Boston 2023 Recap

First Things First Thank you to everyone who attended my session “Answering the Automator’s Call with Automation.” My slide deck and demo code are now available on my Github.....

2023-10-16 (first published: )

57 reads

Blog Post

Seeking Home Network Happiness

TL;DR: My home firewall/router is slow, please help me pick out a new one.
After replacing my firewall/router/WiFi access point one too many times, I’m ready to get off the...

2022-12-27

100 reads

Blog Post

PASS Data Community Summit 2022

As I write this, it’s the weekeend before PASS Data Community Summit 2022 and depending upon when I finish, it’ll post either shortly before SQL Saturday Oregon, or in...

2022-11-12

35 reads

Blogs

My 2024 in Data: Reading

By

This is my last week of the year working (I guess I come back...

My 2024 in Data: Speaking

By

This is my last week of the year working (I guess I come back...

Top 5 Advanced SQL Courses for 2025 (Must-Know)

By

Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...

Read the latest Blogs

Forums

Need ADF pipeline suggestion to copy 1 million files

By varunkum

I have an ADF pipeline that copies Files from source to destination. Both Source...

Backup issues

By Bruin

I''m running a stripped backup (2 files) to a Network share. It's a 32gig...

Function Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Function Defaults

Visit the forum

Question of the Day

Function Defaults

I have created this function in SQL Server 2022:

CREATE FUNCTION dbo.AddInt (@one INT, @two INT = 1) RETURNS INT
AS
BEGIN
    RETURN @one + @two
END
How can I call this and invoke the default value for @two?

See possible answers