Deb Melkin (b | t) is hosting T-SQL Tuesday this month and is letting us rant. Who doesn’t like to rant about databases and the famous “it depends”. She...
2022-07-13 (first published: 2022-07-12)
25 reads
Over the last four years, ok it seems longer than that, I’ve started four jobs. A couple just weren’t good fits. One I was at for three years. I...
2022-07-11 (first published: 2022-06-27)
658 reads
In my previous post, I expounded on my first 30 days I had at four jobs in the last four years. and how to setup your jobs box. I...
2022-07-05
40 reads
Now that your CFS has been setup it’s time to get the word out first. There are many ways to this. I start with using the Cfs secret page...
2022-07-01
37 reads
Having recently taken a new job and introducing a number of new tools to my new coworker I thought I’d share how I setup my jump box to and...
2022-06-28
17 reads
SQL Server can run in any Virtual Machine that has the appropriate operating system (yes, I said that because I have some hope, that we will one day learn...
2022-06-20 (first published: 2022-06-03)
444 reads
It’s that time of the month again, the blog party, woohoo! This time Mala Mahadevan (b | t) has invited us to blog about our T-SQL coding standards. I...
2022-06-14
43 reads
I had a problem at work recently where a record was getting updated, and no one knew where or what was updating the record. Our team discussed the best...
2022-06-14
156 reads
I jumped on the bandwagon early so to speak to use the user group feature of Sessionize and since then I’ve walked at least five user groups through setting...
2022-05-31
25 reads
It’s that time of the month again, the blog party, woohoo! This time Kenneth Fisher (b | t) has invited us to blog about our first tech job. Oh...
2022-05-30 (first published: 2022-05-10)
170 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