SQL Server Database Source Control using VSO Git
For a while now, I have ensured that the source code of new projects that I have undertaken (in both...
2015-10-26
229 reads
For a while now, I have ensured that the source code of new projects that I have undertaken (in both...
2015-10-26
229 reads
The SSIS Project Deployment Model is great! It really is the best thing since sliced bread! I specifically appreciate the...
2015-07-15 (first published: 2015-07-06)
2,752 reads
When SQL Server Reporting Services (SSRS) successfully renders a given report control (i.e. Table, Matrix, List etc.), the result set can...
2015-06-24 (first published: 2015-06-15)
2,229 reads
Dynamically initialise FTP connection using expressions and retrieve files stored in multiple FTP directories using SQL Server Data Tools
2013-03-11
8,409 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