How do I test if a linked server works using T-SQL?
I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they ... Continue reading
2020-10-29 (first published: 2020-10-27)
830 reads
SQLStudies
SQL Virtual Machines
I was recently watching the first session of the Azure SQL Bootcamp by Anna Hoffman (twitter) and Bob Ward (blog|twitter) ... Continue reading
2020-10-22
172 reads
My 800th post!
It took me a little bit longer to get here than I expected but I finally made it. 800 posts. ... Continue reading
2020-10-20
3 reads
Permissions script for Azure Synapse
I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for ... Continue reading
2020-10-22 (first published: 2020-10-15)
259 reads
A table is like a library : T-SQL Tuesday #131
Rob Volk (blog|twitter) is our host for TSQL Tuesday this month and wants us to Explain a database subject like ... Continue reading
2020-10-20 (first published: 2020-10-13)
457 reads
All triggers have to be able to handle multiple row operations.
Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s ... Continue reading
2020-09-11 (first published: 2020-09-03)
460 reads
SQL Homework – September 2020 – More DML Triggers
Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all ... Continue reading
2020-09-01
87 reads
As a DBA, am I a gatekeeper?
TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and ... Continue reading
2020-08-27
176 reads
SQL Homework – August 2020 – More DML Triggers
Well, I’m running a bit late. Both for this month and the fact I completely missed last month. It was ... Continue reading
2020-08-13
82 reads
What goes around comes around : T-SQL Tuesday #129
I almost died. I’m sure a lot of you already know this but just to be clear, I should have. ... Continue reading
2020-08-11
17 reads
Blogs
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
My 2024 in Data: Speaking
By Steve Jones
This is my last week of the year working (I guess I come back...
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Forums
Need ADF pipeline suggestion to copy 1 million files
I have an ADF pipeline that copies Files from source to destination. Both Source...
Function Defaults
Comments posted to this topic are about the item Function Defaults
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