What Permissions do I need to generate a deploy script with SSDT?
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or...
2015-04-21
58 reads
Ed Elliott's Sql Developer Blog
What Permissions do I need to generate a deploy script with SSDT?
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or still automatically but at a later date plus you...
2015-04-21
1 reads
HOWTO-Get-T-SQL-Into-SSDT
Ok so you have created an SSDT project and are currently congratulating yourself on how awesome and cool you are...
2015-04-08
591 reads
HOWTO-Get-T-SQL-Into-SSDT
Ok so you have created an SSDT project and are currently congratulating yourself on how awesome and cool you are...
2015-04-08
29 reads
HOWTO-Get-T-SQL-Into-SSDT
Ok so you have created an SSDT project and are currently congratulating yourself on how awesome and cool you are...
2015-04-08
26 reads
HOWTO-Get-T-SQL-Into-SSDT
Ok so you have created an SSDT project and are currently congratulating yourself on how awesome and cool you are but then you realise that your project is like...
2015-04-08
2 reads
Generating tSQLt tests from a dacpac
Generating tSQLt tests from a dacpac
I use SSDT and tSQLt in my work and I am always interested in productivity...
2015-04-02
1,225 reads
Generating tSQLt tests from a dacpac
UPDATE I went and built this into my add-in for SSDT, more details https://the.agilesql.club/blog/Ed-Elliott/2015-11-17/Create-Stub-tSQLt-t… and https://the.agilesql.club/Projects/SSDT-Dev-Pack
Generating tSQLt tests from a...
2015-04-02
41 reads
Generating tSQLt tests from a dacpac
UPDATE I went and built this into my add-in for SSDT, more details https://the.agilesql.club/blog/Ed-Elliott/2015-11-17/Create-Stub-tSQLt-t… and https://the.agilesql.club/Projects/SSDT-Dev-Pack
Generating tSQLt tests from a...
2015-04-02
26 reads
Generating tSQLt tests from a dacpac
UPDATE I went and built this into my add-in for SSDT, more details https://the.agilesql.club/blog/Ed-Elliott/2015-11-17/Create-Stub-tSQLt-t… and https://the.agilesql.club/Projects/SSDT-Dev-Pack
Generating tSQLt tests from a dacpac I use SSDT and tSQLt in my work...
2015-04-02
Blogs
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
My 2024 in Data: Speaking
By Steve Jones
This is my last week of the year working (I guess I come back...
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Forums
Need ADF pipeline suggestion to copy 1 million files
I have an ADF pipeline that copies Files from source to destination. Both Source...
Function Defaults
Comments posted to this topic are about the item Function Defaults
Question of the Day
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