SQLStudies

Blog Post

Talk to the duck.

Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is ... Continue reading

2022-04-15 (first published: )

329 reads

Blogs

My 2024 in Data: Reading

By

This is my last week of the year working (I guess I come back...

My 2024 in Data: Speaking

By

This is my last week of the year working (I guess I come back...

Top 5 Advanced SQL Courses for 2025 (Must-Know)

By

Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...

Read the latest Blogs

Forums

Backup issues

By Bruin

I''m running a stripped backup (2 files) to a Network share. It's a 32gig...

Function Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Function Defaults

Big Data or Small Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Big Data or Small Data

Visit the forum

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