Scripting database objects in SQL Server 2008
In this article, we would go through the
steps to script the objects in a database using SQL Server 2008....
2010-03-18
2,663 reads
bruhaspathy@hotmail.com
- Interests: SQL Server, watching and playing tennis, reading books
Performing SSAS Database Backup
In this post, we will look the steps to backup a SQL Server Analysis Server Database.
After logging to the Analysis Services,
in...
2010-02-08
1,703 reads
Concatenating Strings to NULL values
We recently ran into this situation of reports containing nothing but blank spaces. When investigated the reason was that the String...
2010-02-01
2,483 reads
Perform a Striped Backup
The size of databases have been growing in such a way, it sometimes is hard to have a single drive / tape to...
2009-12-16
2,636 reads
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
Function Defaults
Comments posted to this topic are about the item Function Defaults
Big Data or Small Data
Comments posted to this topic are about the item Big Data or Small Data
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