Creating an alias for a SQL Server is fairly easy and there are several ways to do it. Configuration Manager...
2014-06-20 (first published: 2014-06-18)
2,329 reads
A couple of weeks ago I did a post on granting or denying permissions to all the tables within a...
2014-06-16
1,161 reads
I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge...
2014-06-12
837 reads
A little while back Michael J Swart(B/T) offered to help you become a better writer. This was exciting for me...
2014-06-09
879 reads
An identity column is an auto incrementing columnAn identity column is typically used as a primary keyA primary key that’s...
2014-06-04
1,046 reads
One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4)....
2014-06-02
1,707 reads
The other day I started seeing the following error in my SQL log.
Error: 17810, Severity: 20, State: 2.
Could not connect...
2014-06-05 (first published: 2014-05-28)
2,472 reads
If you have spent any time looking around my site, you will notice that I love study materials and in...
2014-05-26
1,177 reads
Typically when you see a heading like this you know the answer is “No” or “False” but in this case...
2014-05-21
2,618 reads
Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon...
2014-05-27 (first published: 2014-05-19)
1,728 reads
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...
By Steve Jones
This is my last week of the year working (I guess I come back...
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