Presentation slides and sql scripts up
I have posted the slides for the presentation I gave to the DotNet Columbia User Group.
The talk was called, "Something...
2006-08-09
705 reads
I have posted the slides for the presentation I gave to the DotNet Columbia User Group.
The talk was called, "Something...
2006-08-09
705 reads
If you're like me, you don't have SQL Server 2005 sitting on the
default instance because SQL Server 2000 is sitting...
2006-08-06
651 reads
SQL Server MVP Nigel Rivett has written an excellent article on Common Table Expressions on Red Gate Software's Simple Talk...
2006-08-02
744 reads
I saw this post on using Fiddler to tell the difference between an NTLM and a Kerberos connection to a...
2006-08-02
4,510 reads
This is a follow-on to Does your organization need a DBA? and Andy Leonard's Database Professionals: An Enterprise Requirement.
I was...
2006-08-01
688 reads
Andy Leonard pens the following blog entry:
Database Professionals: An Enterprise Requirement
There are quite a few organizations that feel they can...
2006-07-30
1,530 reads
Encrypting File System, or EFS, first debuted in Windows 2000 and gave
users to encrypt files without a 3rd party tool....
2006-07-30
1,580 reads
There is a new post in the SQL Server Express blog which indicates the
right way to detect SQL Server 2005:...
2006-07-29
1,468 reads
There is a new site for SQL Server blogs, SQLBlog.com. "Brought to you by Peter DeBetta & Adam Machanic," it has...
2006-07-29
1,311 reads
If you're keeping up with Windows Vista and you're interested in the
security aspects of it, there's a new blog, with...
2006-07-29
1,382 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 ENDHow can I call this and invoke the default value for @two? See possible answers