Perl has been a popular language for Unix administrators for years. It is flexible, easy to learn, and capable of doing some very powerful things with relatively few lines of code. In this article by Brian Kelly, he shows you how to connect to SQL Server via Perl.
2006-07-28 (first published: 2002-12-03)
42,093 reads
Haidong Ji, co-author of Professional SQL Server 2005 Integration Services, blogged on Learning Perl using the Perl Debugger. Haidong posts...
2006-07-27
1,589 reads
Channel 9 has posted a 25 minute interview with Craig Mundie, Chief Research and Strategy Officer for Microsoft. You can...
2006-07-27
1,646 reads
As reported in several other places... there is a new Books Online (July 2006) for SQL Server 2005. You can...
2006-07-25
1,897 reads
Check out this post:
Things to consider before submitting an incident to Microsoft
Getting the information together before you make that phone...
2006-07-20
2,344 reads
I'll be presenting at the DotNet Columbia SC User Group on August 8th.
My presentation is tentatively titled, "Something old, something...
2006-07-20
1,631 reads
There is a very interesting article about how MSDN 2 utilizes SQL
Server 2005 technologies, specifically Service Broker and CLR
integration. The...
2006-07-20
1,513 reads
I saw this on a Channel 9 forum thread:
Library of Free Data Models
There are quite a few starter data models...
2006-07-19
1,909 reads
I was catching up on my blog reading (unfortunately, in some cases I'm
a month behind) and came across a link...
2006-07-14
1,450 reads
There is are two new KB articles on how the file growth value can become abnormally large. You can find...
2006-07-13
1,604 reads
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...
By Steve Jones
This is my last week of the year working (I guess I come back...
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