In addition to being an amazing opportunity for both technical and professional development, PASS Summit is a #sqlfamily reunion and a huge networking event. Catching up with old friends,...
2018-10-29
Welcome to the new home of my blog! I’ve had this domain for over a year but with PASS Summit 2018 coming up soon I decided it was time...
2018-10-28
This month’s T-SQL Tuesday is hosted by Jeff Mlakar and he asks us to write about a project that went horribly wrong. My story isn’t really worthy of the...
2018-10-10
This is my third installment in a series responding to Steve Jones’s (blog|twitter) #SQLCareer challenge. I decided to jot down most of what I did through the day, filling...
2018-09-24
The first edition of the PSPowerHour is in the books and it looks like it was a big success. This one was dbatools-heavy but I chalk that up to...
2018-08-23
Kevin Hill (blog|twitter) posted a thought-provoking item on his blog last week about Disaster Recovery Plans. While I am in the 10% who perform DR tests for basic functionality...
2018-08-16
This is my second installment in a series responding to Steve Jones’s (blog|twitter) #SQLCareer challenge. I decided to jot down most of what I did through the day, filling...
2018-08-15
A few weeks ago, I teased good news.
just got some good news. can't wait to share it
— Andy Levy (@ALevyInROC) July 20, 2018 One person hypothesized that I’m...
2018-08-14
It’s official! I will be speaking at the inaugural PowerHour online lightning demo event on Tuesday, August 21st at 2200 UTC. I’ll be demoing Better, Safer SQL Queries from...
2018-08-14
This is my first installment in (I hope) a series responding to Steve Jones’s (blog|twitter) #SQLCareer challenge. I decided to jot down most of what I did through the...
2018-08-08
1 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
This is my last week of the year working (I guess I come back...
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...
I have an ADF pipeline that copies Files from source to destination. Both Source...
Comments posted to this topic are about the item 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