Avi Niv

Randomized color report? So help my CODE!

Writing a Reporting Services report can be challenging, making you use the most of...

2014-07-01

1,621 reads

Generating Email Reports using XML

SQL Server has some handy features: one of those features is dbmail, which I tend to use less until I’ve...

2014-06-19

722 reads

Recently we deployed database mirroring in an environment with an Active Directory. The process is usually quite simple and straight-forward,...

2014-03-04

604 reads

Recently I was asked to investigate a timeout issue that was causing SSIS package executions to fail.
The timeouts seemed to...

2013-12-30

1,273 reads

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?