John

John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, 2016 Idera Ace, Friend of Red Gate since 2015, Sentry One PAC member & Community Ambassador. John has passion around speaking, teaching technical topics and giving back to the technical community. He is a user group leader, SQL Saturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQL Saturday's as well as other conferences. If you want to find John, you can find him on Twitter (@sqlrus) or on his blog, http://sqlrus.com.

Blog Post

Happy New Year!

Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that...

2021-01-01

6 reads

Blog Post

Happy New Year!

Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that...

2021-01-01

4 reads

Blog Post

Happy New Year!

Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that...

2021-01-01

4 reads

Blog Post

Happy New Year!

Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that...

2021-01-01

2 reads

Blog Post

Happy New Year!

Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that...

2021-01-01

3 reads

Blog Post

Happy New Year!

Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that...

2021-01-01

2 reads

Blog Post

Happy New Year!

Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that...

2021-01-01

3 reads

Blog Post

Happy New Year!

Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that...

2021-01-01

1 reads

Blog Post

Happy New Year!

Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that...

2021-01-01

1 reads

Blogs

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...

My 2024 in Data: Travels

By

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

Read the latest Blogs

Forums

Function Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Function Defaults

Big Data or Small Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Big Data or Small Data

Level 4 of the Stairway to Synapse Analytics: Create and Use a Delta Lake

By Sucharita Das

Comments posted to this topic are about the item Level 4 of the Stairway...

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