Error : Database backup is getting fail with below reason.
The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is...
2014-08-11
1,150 reads
Today’s editorial at SQLServerCental is entitled: We Don’t Care about Data and IT Security. It’s by Brian Kelley (author, blog,...
2014-08-11
570 reads
Like:- This operator is used in a WHERE clause to search for a specific pattern in the values of the...
2014-08-11
434 reads
1. All the tables in the database have properly defined relationship using primary keys and foreign keys .
2. Indexes should...
2014-08-11
2,302 reads
This function is used to select the values within a specified range. These values can be of Int type or...
2014-08-11
361 reads
Left():- This function returns the specified number of characters from the left part of the given character string.
Syntax:-
Select LEFT ( character_expression...
2014-08-11
972 reads
Right():- This function returns the specified number of characters from the Right part of the given character string.
Syntax:-
Select RIGHT ( character_expression...
2014-08-11
774 reads
This function is used to returns distinct values that are returned by both the query on the left and right...
2014-08-11
1,088 reads
SQL server gives the exception/error handling mechanism which is similar to c#, Try..Catch block. In SQL Server, we can write...
2014-08-19 (first published: 2014-08-11)
10,251 reads
If you’re reading this, you probably think, like me, that SQL Server is an awesome product. One of the great...
2014-08-11
1,396 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