The concept of a synonym was introduced in SQL Server 2005. Synonyms are very simple database objects, but have the potential to save a lot of time and work if implemented with a little bit of thought. This article discusses what exactly a synonym is, and a few examples of how to use them.
2016-06-24 (first published: 2014-09-11)
25,079 reads
2010-06-09
4,102 reads
Testing and analysis of new backup compression and table/index compression features of SQL Server 2008.
2010-04-22
7,656 reads
Comparison of performance of SQL 2008 mirroring to SQL 2005 mirroring.
2008-12-10
7,449 reads
2008-11-14
9,676 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
This is my last week of the year working (I guess I come back...
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...
I have an ADF pipeline that copies Files from source to destination. Both Source...
Comments posted to this topic are about the item 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