SQL Homework – March 2022 – Formatting
Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries ... Continue reading
2022-03-01
17 reads
SQLStudies
SQL Homework – March 2022 – Formatting
Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries ... Continue reading
2022-03-01
1 reads
I’m writing a SQL Server security presentation and I need your help.
I’m working on a new presentation titled Watch Ken solve security headaches in SQL Server. In this presentation I’m going ... Continue reading
2022-03-14 (first published: 2022-02-24)
307 reads
I’m writing a SQL Server security presentation and I need your help.
I’m working on a new presentation titled Watch Ken solve security headaches in SQL Server. In this presentation I’m going ... Continue reading
2022-02-24
1 reads
Help, not all of my column is displaying in the output of the query!
I’ll be honest, I don’t remember if I’ve written about this before but I couldn’t find it, so here we ... Continue reading
2022-03-09 (first published: 2022-02-22)
346 reads
Help, not all of my column is displaying in the output of the query!
I’ll be honest, I don’t remember if I’ve written about this before but I couldn’t find it, so here we ... Continue reading
2022-02-22
1 reads
You can’t use GO in dynamic SQL.
This is one of those things that when I look back on it seems really obvious. Note: If at the ... Continue reading
2022-02-25 (first published: 2022-02-10)
715 reads
You can’t use GO in dynamic SQL.
This is one of those things that when I look back on it seems really obvious. Note: If at the ... Continue reading
2022-02-10
7 reads
Who do you contact before an upgrade? : T-SQL Tuesday #147
I haven’t been blogging as much recently as I’d like and I’m trying to get back into it. One excellent ... Continue reading
2022-02-18 (first published: 2022-02-09)
228 reads
Who do you contact before an upgrade? : T-SQL Tuesday #147
I haven’t been blogging as much recently as I’d like and I’m trying to get back into it. One excellent ... Continue reading
2022-02-09
2 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
Function Defaults
Comments posted to this topic are about the item Function Defaults
Big Data or Small Data
Comments posted to this topic are about the item Big Data or Small Data
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