Main Content

Please wait...
1. nchar[(n)] (national character) i. Fixed-length Unicode string data. ii. n defines the string length and must be a value from 1 through 4,000. iii. The storage size is two times n bytes. 2. char [(n)] (character) i. Non-Unicode string data with fixed-length. ii. n defines the string length and must be a value from 1 through 8,000. iii. Storage size is n bytes. 3. varchar [(n | max)] (character varying) i. Variable-length, non-Unicode string data. ....Read More

What's new in SQL Server 2019?

Microsoft announced the latest preview of SQL Server 2019 on this September and Celebrating 25 years of SQL Server Database Engine since SQL Server first shipped on Windows NT in 1993. In every release of SQL server, Microsoft makes inner optimizations that enhance performance. In this release there is no License or support it only available for experiments. SQL Server 2019 makes a brought together information stage with Apache SparkTM and Hadoop Dispersed Record Framework (HDFS) bundled toge ....Read More

TRIM Function in SQL Server 2017

we can see that most of the languages have the trim function. But, Today I am going to write about Trim Function in SQL Server 2017. Trim Function helps to remove White spaces or other specified characters from the start as well as the end of the String. Syntax: TRIM ( [ characters FROM ] string )  Where Characters represents variable, literals or function call of any non-LOB character types (nvarchar, varchar, nchar, or char). But Data type like. varchar(max) and nvarchar(max) are not all ....Read More

Hosting ASP.NET Core Web API on IIS

This article will help you to host ASP.NET core Web API in IIS by using Visual Studio. core web application deployment is not the same as Asp.Net, there are some few more components that are needed with hosting your core 2.0 applications on IIS. Before deploying, you must install a bundle which is required to host Asp.Net Core 2.0 application on IIS and that is, .Net Core Windows Server Hosting. This bundle will install.Net Core Runtime which gives all the necessary libraries at ....Read More

How to install IIS on Windows 10?

Steps to Install IIS on Windows 10: Step 1: Go to the window search bar in Type Control Panel, as shown in the image below. Step 2: Under ‘programs and features” option, click on it. Step 3: Now On the left-hand side you’ll find “Turn Windows feature on or off” option, just click on it Step 4: Here, you will find various features. Just Check “Internet Information Services” radio button to activate it. Step 5: Now click on ‘+’ sig ....Read More