Blog

IIF Statement in SQL IIF statement is introduced in SQL Server 2012. We can say it's a shorthand version of CASE statement. If you come from .net world, you can relate IIF in SQL with IIF in visual basic language. The IIF in SQL Server gives one of two values, based on whether the Boolean phrase assesses to genuine or wrong in SQL Server. The important thing to remember here is that this IIF is [...]

In this article, we’ll review how to parse PDF invoices and get result data in CSV format using ByteScout Document Parser SDK and SharePoint. Basically, We’ll be following these steps. Create a SharePoint project in Visual Studio Give reference to Document Parser SDK Create WebPart and implement Invoice parsing logic We won’t be going into macro-level details of how to create a SharePoint extension with Visual Studio. Instead, we’ll be focusing on the code. The [...]

NTILE is one of the ranking functions in SQL Server. NTILE function is used in scenarios where we have a requirement to divide the result set into some quarters, and with each row, we want to get that quarter's number. We might think of real-life situations such as suppose we have to get email addresses for campaigning from a database. And we also want that these returned emails are divided into four groups. The NTILE [...]

Both RANK and DENSE_RANK are windows functions. These functions are used to give ranking based on their order and based on their order in respective partition/group. Let's take a look in more detail. DENSE_RANK: It is an analytic query that calculates the position of a row in a positioned array of rows. The resulted rank is a number beginning from 1. DENSE_RANK is one of the most crucial analytical functions. It gives rank as sequential [...]

ROW_NUMBER() is one of the windows functions in the SQL server, used to the current number of rows in the result set based on an ORDER BY statement and sometimes based on an ORDER BY within a particular group. In SQL Server, the ROW_NUMBER() is a window function. In other words, it is also called an analytical function. This function is essential for various data breakdowns and interpretation. In this, it allocates a sequential number [...]

Scopes in SQL are different from languages like C#, C, Java, etc. If we talk about a particular language, say C#, then each statement in a block has a different scope. Typically, a variable is unrestricted and plays between when announced and the ending of the batch, function, or procedure that it is defined in. It is clear, but it is uncomplicated to overlook what comprises a batch. The scope of a variable is the [...]

The WAITFOR statement is used to stop the execution of the current transaction/Stored procedure until delay time or specified time. How to Use WAITFOR? It can be used with different combinations like DELAY, TIME, or till for service brokers to receive messages. If multiple WAITFOR statements are defined on the identical server, multiple lines can be connected up waiting for these statements to execute. SQL Server observes the number of WAITFOR statement lines and erratically [...]

If you are into software development, you might have heard about the terms SDK, JDK, NDK, and APK. All of them are related to software or app development in some way. However, there are a few differences that separate them from each other. This article has compared all these terms and explained everything you need to know about them. SDK SDK (Software development Kit) is a toolkit where developers can create new applications for different [...]

WHILE keyword loops statement inside it, until condition specified by it satisfies. There are often chances for WHILE loop to go into an infinite loop, so we have to make sure to update necessary variables if any inside while block. Its syntax is very simple, as listed BELOW. Keyword CONTINUE is used if want to skip the rest of the statements in the WHILE loop and go directly to the condition evaluation part. BREAK keyword [...]

When it comes to decision-making, there are always conditions on which decisions are formed. In other words, there are If-Else. From Assembly languages to modern languages, it-else is and was a very common part of them. In real life also there are if-else when it comes to decision making if we take the example of the mindset of employees when it comes to getting a raise. He thinks, "if I got a good raise this [...]