sp_BulkExport:Export Data from TSQL without using xp_cmdshell - uses SQLDMO and sp_OA*. Supports a variety of formats and options. In my testing on a 22 million-row table it is NOT as fast as BCP. This is the first rev of the proc and it has not been thoroughly tested.
2004-09-16 (first published: 2004-06-25)
929 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
END
How can I call this and invoke the default value for @two? See possible answers