T-SQL Tuesday #168–Roundup
Last week was the 168th T-SQL Tuesday, which I hosted. The invitation is here. I didn’t get much of a chance to check out the posts as I was...
2023-11-21
18 reads
Blog Posts
How to write efficient TSQL
This is an article on How to write efficient TSQL. When it comes to composing T-SQL (Transact-SQL) code, there exist a multitude of vital considerations developers should bear in...
2023-11-20 (first published: 2023-11-06)
990 reads
Microsoft Fabric is now GA!
After more than two years in development and six months in public preview, Microsoft Fabric is now generally available (GA). Here is the announcement made during Microsoft Ignite last...
2023-11-20
23 reads
Running a Command Line SQL Compare Comparison
Recently a customer was looking to automate some of their SQL Compare checks, but they wanted to do this in a dynamic way, since they needed to do this...
2023-11-20 (first published: 2023-11-08)
382 reads
A New Word: Vaucasy
vaucasy – n. the feat that you’re little more than a product of your circumstances, that for all the thought you put into shaping your believes and behaviors and...
2023-11-17
26 reads
Help! My Docker SQL Instance Won’t Start!
One day, I shut down my computer, as I usually do nightly. This time, I shut it down on a Friday and turned it back on after a holiday...
2023-11-17 (first published: 2023-11-03)
173 reads
What is Azure SQL
I get asked about Azure SQL very often. This is a topic that I’ve written about and taught many times. To be honest, this is a rather large topic...
2023-11-17 (first published: 2023-10-25)
393 reads
PASS Data Summit 2023 KeyNote 2
Morning from the PASS Data Summit! I will be live blogging the event again today, so check back for announcements and releases throughout the keynote. Today, we will dive...
2023-11-16
58 reads
Women in Tech: Finding Allies #PASSDataSummit
The WIT panel spoke on an excellent topic today: needing, and finding, allies at work. Afterward and for the first […]
The post Women in Tech: Finding Allies #PASSDataSummit appeared...
2023-11-16
39 reads
Adding a Foreign Key in the CREATE TABLE statement–#SQLNewBlogger
I had someone ask this question recently and had to double check the syntax myself, so I thought this would make a nice SQL New Blogger post. Another post...
2023-11-15 (first published: 2023-10-30)
319 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