IIF vs CHOOSE in SQL Server
IIF and CHOOSE are two logical functions in SQL Server used for different purposes. Here we will see the competition of IIF vs CHOOSE.
Articles about Microsoft technologies like Windows, SQL server, MS Office, Sharepoint, IIS, Dot Net, etc..
IIF and CHOOSE are two logical functions in SQL Server used for different purposes. Here we will see the competition of IIF vs CHOOSE.
Here is a simple tip to insert multiple records in an SQL Server database table with a single SQL insert query.
In rare situations like database level permission issues, you may need to drop all the tables from a SQL Server database and recreate them.
CHOOSE is a Transact-SQL function used to return a single value form a list based on the specific index. Let’s see how to use CHOOSE function.
In this article, we will see how to make an SQL Script to sleep for some time with examples.
This article intends to provide helpful information to make your search for a suitable development environment easier by describing the benefits and drawbacks of using .NET as a software development platform.
If you are not taking precautions while using connection pooling, you may encounter errors. Here are a few of the common errors and ways to prevent connection pool problems.
What is SQL, and why is SQL important? let’s figure it out. All valuable information is organized and entered into databases managed by database management systems and the SQL language.
Here is the sample code to calculate mode in C# for a set of numbers in an array. This method will get you single mode or multi modes.
It is easy to calculate mean in C#, as arithmetic mean is just the average of the collection of numbers. Here is the sample code.
In this article we will see how to calculate median in c# .Net by coding the median algorithm by yourself and by using a 3rd party library.
Let us see with example on how to calculate the mathematical statistical mode in SQL Server.
Here you will see with a simple example on using an existing TSQL function to calculate the mean in SQL Server.
One another simple method to get the execution time in milliseconds in SQL Server Management Studio (SSMS)
Here we will see couple of methods to perform an IF…THEN Operation in SQL Server SELECT statement.
Developing an application with database, frequently you will need to provide option to update if a row exists else insert a row.
There is no straight forward way to update identity values. Here is a workaround I have followed to get the work done.
Here is one another simple way to calculate median using the PERCENTILE_CONT function introduced in SQL Server 2012.
In this article, we will see how to import data from JSON file to a table using OPENROWSET and OPENJSON T-SQL relational operators.
To export a table to JSON file, I have used FOR JSON clause to format the retrieved data as JSON and ran the BCP command through XP_CMSSHELL.