paddythegeek

Summarizing Imported Data

This article shows a few simple techniques to summarize table data using T-SQL.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.4 (5)

You rated this post out of 5. Change rating

2012-07-27

2,020 reads

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

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

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

Comments posted to this topic are about the item Function Defaults

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

Comments posted to this topic are about the item Level 4 of the Stairway...

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?