You want sysadmin permissions in production? And your manager has approved it so I shouldn’t have any problems giving it ... Continue reading
2020-05-01 (first published: 2020-04-20)
691 reads
The SQL_VARIANT data type is an interesting beast. It is a data type that can store most types of data. ... Continue reading
2020-04-27 (first published: 2020-04-16)
598 reads
Happy T-SQL Tuesday again! Number 125. I can’t believe how long this thing has been running. In case you weren’t ... Continue reading
2020-04-14
12 reads
I get asked this every now and again, along with the companion When was the last time this login was ... Continue reading
2020-04-20 (first published: 2020-04-08)
886 reads
The other day Kendra Little (blog|twitter) mentioned that she was trying to get a command in Powershell working. Specifically one ... Continue reading
2020-04-13 (first published: 2020-04-06)
654 reads
Normally for April 1st I’d try to post something a bit more lighthearted but with the state of the world ... Continue reading
2020-04-01
5 reads
The system variable @@ERROR is a quick and easy way to retrieve the error number from the last statement run ... Continue reading
2020-04-06 (first published: 2020-03-30)
374 reads
TL;DR; You probably don’t know what you’re going to get. Even if you do know the person maintaining your code ... Continue reading
2020-03-30 (first published: 2020-03-25)
762 reads
It’s amazing the things that SQL can do these days. It’s also amazing how many of them I’ve managed to ... Continue reading
2020-03-23
278 reads
A while back a company I worked for had two teams. One was a development team and the other was ... Continue reading
2020-03-19
108 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