What The Tool? Multiple choice quiz to help you choose a tool for SQL Server
There are a few different choices for tools to use when it comes to SQL Server, while the “experienced” amongst...
2017-12-14
33 reads
There are a few different choices for tools to use when it comes to SQL Server, while the “experienced” amongst...
2017-12-14
33 reads
There are a few different choices for tools to use when it comes to SQL Server, while the “experienced” amongst...
2017-12-14
34 reads
There are a few different choices for tools to use when it comes to SQL Server, while the “experienced” amongst us have used query analyzer, enterprise manager and probably...
2017-12-14
2 reads
Writing infrastructure as code is pretty nice and I enjoy the declarative approach of defining what you want and letting...
2017-12-13
38 reads
Writing infrastructure as code is pretty nice and I enjoy the declarative approach of defining what you want and letting...
2017-12-13
34 reads
Writing infrastructure as code is pretty nice and I enjoy the declarative approach of defining what you want and letting the tooling take care of the how. I guess...
2017-12-13
ARMED, where is the source?
For quite a few years I’ve been putting everything I wrote on github and made most...
2017-12-09
31 reads
ARMED, where is the source?
For quite a few years I’ve been putting everything I wrote on github and made most...
2017-12-09
297 reads
ARMED, where is the source?
For quite a few years I’ve been putting everything I wrote on github and made most...
2017-12-09
39 reads
ARMED, where is the source?
For quite a few years I’ve been putting everything I wrote on github and made most...
2017-12-09
6 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 ENDHow can I call this and invoke the default value for @two? See possible answers