Be sure to watch this week’s video to get the full behind the scenes experience! Today I want to share my process for blogging and making weekly YouTube videos....
2019-07-19 (first published: 2019-07-02)
376 reads
Watch this week's video on YouTube
In order to stay current in a technology you have to immerse yourself in community content.
Documentation is good for knowing the specification of a...
2019-07-16
1 reads
Watch this week's video on YouTube
In order to stay current in a technology you have to immerse yourself in community content.
Documentation is good for knowing the specification of a...
2019-07-16
Watch this week’s video on YouTube. This week I want to share something that surprised me about using SQL Server’s SET IDENTITY_INSERT statement. I started with two tables with...
2019-07-10 (first published: 2019-06-25)
471 reads
Watch this week's video on YouTube
Today I want to share with you an interesting observation I made about SELECT expression execution order.
I was working on writing a dynamic SQL...
2019-07-09
2 reads
Watch this week's video on YouTube
Today I want to share with you an interesting observation I made about SELECT expression execution order.
I was working on writing a dynamic SQL...
2019-07-09
3 reads
Watch this week’s episode on YouTube. A long time ago I built an application that captured user input. One feature of the application was to compare the user’s input...
2019-07-03 (first published: 2019-06-18)
1,001 reads
Watch this week's video on YouTube
Today I want to share my process for blogging and making weekly YouTube videos.
I've been hesitant to write this post because of how much...
2019-07-02
2 reads
Watch this week's video on YouTube
Today I want to share my process for blogging and making weekly YouTube videos.
I've been hesitant to write this post because of how much...
2019-07-02
This past weekend I had a blast presenting Joker’s Wild with Erin Stellato (blog|twitter), Andy Mallon (blog|twitter), and Drew Furgiuele (blog|twitter). Watch it here! Table of contents: What is...
2019-06-25 (first published: 2019-06-11)
444 reads
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...
By Steve Jones
This is my last week of the year working (I guess I come back...
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