Hello, folks today I am going to migrate one of my projects called Know Your Mentor which was built in ASP.NET Core Project.json. As now Microsoft has moved towards old csproj extension which is Visual Studio .NET C# Project file extension. Continue reading
Guid is a 16-byte binary data type that is globally unique. GUID stands for Global Unique Identifier. Guid are globally unique between table, databases, servers. Continue reading
EOMONTH Function is used to return last day of the month of the specified date. Continue reading
Choose function in SQL Server is used to get the item at the specified index from the list of available values. The index position starts with 1.
If the mentioned index is greater or less than the specified values, It results null.
If we pass the float value in the index it will be converted to an integer, based on that the value will be selected.
If function returns the one of the two values, depending on the condition evaluates true or false.
The IIF function is like Ternary operator in a programming language with single condition.