If you create functions or stored procedures from SQL Server 2005 Management Studio, you will notice that the new window is filled with a template. In general, you get a skeleton interspersed with markers. This article discusses how you can use templates.
2006-11-02
2,522 reads
2006-11-01
1,263 reads
2006-10-27
1,550 reads
2006-10-23
1,622 reads
Learn how to make life easier by dividing large tables and indexes into smaller parts.
2006-10-23
3,774 reads
It's small and neat but it might just save your data...Robyn Page's crib sheet tells you everything you wanted to know about SQL Server backup but were afraid to ask.
2006-10-20
4,868 reads
The .NET Framework 2.0 and Visual Studio 2005 make it easy to create a basic but extensible database-monitoring solution without a lot of complexity or coding.
2006-10-18
4,043 reads
Microsoft has come to the rescue for managing large text fields in SQL Server 2005, by creating a few new large value data types. This article explores these new data types.
2006-10-09
2,297 reads
2006-10-02
1,043 reads
Most DBAs manage multiple SQL servers, each handling different needs for your business. Even with the diverse uses for different servers, there is often the need to deploy the same scripts to all servers for various purposes. Author Joe Doherty brings us his scripts and technique for executing a script across multiple servers.
2006-09-27
9,960 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Using CHOOSE()
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
Comments posted to this topic are about the item The DBA is Dead! Long...
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers