BIML is better even for simple packages
BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a...
2015-04-27
42 reads
BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a...
2015-04-27
42 reads
BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a...
2015-04-27
42 reads
When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated “compare & deploy” way.
Manual The manual way is where you...
2015-04-27
2 reads
BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a bucket load of data flow components all at...
2015-04-27
I had the honour of talking at the excellent Sql Saturday Exeter this morning and wanted to share my slides...
2015-04-25
442 reads
I had the honour of talking at the excellent Sql Saturday Exeter this morning and wanted to share my slides...
2015-04-25
30 reads
I had the honour of talking at the excellent Sql Saturday Exeter this morning and wanted to share my slides...
2015-04-25
32 reads
I had the honour of talking at the excellent Sql Saturday Exeter this morning and wanted to share my slides and say thanks to the organisers, sponsors and everyone...
2015-04-25
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or...
2015-04-21
467 reads
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or...
2015-04-21
33 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...
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
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