In this article I am going to explain the ROUND() function of SQL Server.

ROUND function returns the rounded value of numeric field to the specified length or precision. ROUND function accepts 3 parameters.

SYNTAX :

ROUND (numeric_expression , length [ ,function ] )  

1.      numeric_expression : It is an expression of the exact numeric or approximate numeric data type category, except for the bit data type.

2.      Length: It is the precision to which numeric_expression is to be rounded. length must be an expression of type tinyint, smallint, or int. When length is a positive number, numeric_expression is rounded to the number of decimal positions specified by length. When length is a negative number, numeric_expression is rounded on the left side of the decimal point, as specified by length.

3.      Function: It is the type of operation to perform. function must be tinyint, smallint, or int. When function is omitted or has a value of 0 (default), numeric_expression is rounded. When a value other than 0 is specified, numeric_expression is truncated. This is an optional parameter. 

Here in this article I am going to explain how we can handle the error in SQL Server.

SQL server has the built in support to handle the Transact-SQL statements errors. TRY...CATCH constructs allow us to handle the error(s) in SQL server. To use the TRY...CATCH: write the T-SQL statements in TRY section. If any error occurs in TRY section written code, CATCH section T-SQL will be executed and it returns the error description.

In this article I am going to explain how to create Web API CRUD (create, read, update, delete) operation using repository pattern .net framework.

In previous I have explained how to create First Web API Hello World application with repository pattern and how to return data in JSON format from ASP.NET Web API.

Here in this article I am going to create Web API with CRUD operations for Article with Title, description and tags fields.

Prerequisites

-          -Visual Studio 2019

In this article I am going to explain What is Database master key (DMK) in SQL.

*DMK = Database Master Key

The database master key is a symmetric key used to protect the private keys of certificates and asymmetric keys that are present in the database. When we created DMK, it is encrypted by using the AES_256 algorithms and a user-supplied password.

Every database can have a separate DMK and each database can have only one DMK. 

In this article I am going to explain OFFSET and FETCH in SQL Server.

OFFSET and FETCH are introduced in SQL Server 2012. These are used with Select and Order By clause to provide the result set.

OFFSET can only be used with Order By clause.  OFFSET specifies the number of rows to be exclude from the query. Before use the OFFSET make sure value must be equal to zero or greater than otherwise it will give error. Values can’t be negative.

FETCH is optional. FETCH specifies the number of rows to return after the OFFSET. Similar to OFFSET, values can’t be negative. Value should be equal to zero or greater than otherwise it will give error.

In this article I am going to explain how to get random records from SQL SERVER database table.

When I am working on multiple choice question application, I have got requirement every user have different questions on every test attempt. If I am going to attempt the ASP.NET test, get ASP.NET unique questions from ASP.NET category.

Here in this article I am going to explain how we can store and retrieve the different languages (other than English) data from SQL SERVER table.

When working on an application get requirement to store the data of other language than English (multilingual) in database. If you have get any such requirement, you can achieve this following two things:

Set Unicode compatible datatype (ntext, nvarchar, nchar) for table column

Use N (capital) as a prefix before inserting data/text

Example :

First of all, create a table. I have created table to store admin users name.

Create table tblAdmin ( 
EnglishName NVARCHAR(100), 
HindiName nchar(100), 
JapaneseName ntext 
)

Now insert data into table.

insert into
tblAdmin(EnglishName,HindiName,JapaneseName) values(N'Vijay Saklani',
N'विजय सकलानी',N'ビジェイ・サクラニ')

Get the data from table and check the saved data.

Select * from tblAdmin

If you will insert the into table without prefix N, data will not be useful. It will be inserted in question mark (????) form and become garbage. Let’s check with this also:

insert into tblAdmin(EnglishName,HindiName,JapaneseName) values('Vijay Saklani',
'विजय सकलानी','ビジェイ・サクラニ')

Check the inserted data now.

Here in this article I am going to explain how to resolve the @angular/material/index.d.ts' is not a module error.

After upgraded currently working Angular application to Angular 9 and Angular Material 9, I get the error :

@angular/material/index.d.ts' is not a module

Now the question arise why this error comes and how to fix this error.

Reason:

In this article I am going to explain how to add Material in Angular project.

 Angular material is an UI component library.  It is an alternative to bootstrap for Angular application. It provides modern UI components that work across mobile, web and desktop. It is Versatile, Fast and Consistent. You can read more about material component from its website : https://material.angular.io/

Prerequisite :

Visual studio code

In this article I am going explain the all Angular CLI commands.

 The Angular CLI is a command-line interface tool that you use to initialize, develop, scaffold, and maintain Angular applications. You can use the tool directly in a command shell, or indirectly through an interactive UI such as Angular Console.

Follow the below given command as per your requirement :

Here in this article I am going to explain how we can store the multilingual (Hindi, Japanese etc.)  data in SQL SERVER table.

 When working on an application get requirement to store the data of other language than English (multilingual) in database. If you have get any such requirement, you can achieve this following two things: