Sunday, May 16, 2021

16 May

SQL Server : Round function

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 :...

Saturday, April 3, 2021

03 Apr

SQL Server error handling

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...

Sunday, July 19, 2020

19 Jul

Web API : CRUD operation using repository pattern .net framework

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...

Tuesday, July 14, 2020

14 Jul

What is DATABASE MASTER KEY in SQL?

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...

Sunday, June 28, 2020

28 Jun

SQL SERVER : OFFSET and FETCH example

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...

Friday, June 26, 2020

26 Jun

SQL SERVER : Get Random Records from database table

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...

Tuesday, June 9, 2020

09 Jun

SQL SERVER : Store and Retrieve different languages data from Table

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...

Tuesday, June 2, 2020

02 Jun

[Error Solved]: @angular/material/index.d.ts' is not a module

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...

Wednesday, May 27, 2020

27 May

How to add Material in Angular project

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...

Saturday, May 23, 2020

23 May

Angular CLI commands

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...

Friday, May 15, 2020

15 May

SQL SERVER : Store Multilingual (Hindi, Japanese etc.) data in Table

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...

Saturday, April 25, 2020

25 Apr

Routing in ASP.NET Web API

Here in this article I am going to explain Routing in ASP.NET Web API. In previous article I have explained Introduction To ASP.NETWeb API, Create Web API Hello World First Application and how to return data inJSON format from ASP.NET Web API. What is Routing? Routing is a mechanism that handle the incoming request...

Thursday, April 16, 2020

16 Apr

ASP.NET Web API : Return data in JSON format

In this article I am going to explain how to return data in JSON format from ASP.NET Web API. In previous article I have explained how to create First WebAPI Hello World application with repository pattern, how to create Web APIfirst Hello world application and Introduction To ASP.NET Web API. As you know ASP.NET...

Monday, April 6, 2020

06 Apr

Create First Web API Hello World application with repository pattern

In this I am going to explain how to create First Web API Hello World application with repository pattern. In previous article I have explained Introduction to ASP.NET Web API. I am using Visual studio 2019 and .net framework to create this application. Implementation: STEP 1 : Open VS 2019. Click on...

Tuesday, March 10, 2020

10 Mar

Create Web API Hello World First application

In this article I am going to explain how to create Web API first Hello world application. In previous article I have explained Introduction to Web API. I am using Visual studio 2019 and .net framework to create this application. Implementation: STEP 1 : Open VS 2019. Click on create a new project and select...

Sunday, March 8, 2020

08 Mar

Introduction to ASP.NET Web API

Here in this article I am going to give you introduction of ASP.Net Web API. What is Web API? ASP.NET Web API API stands for application programming interface. ASP.NET Web API is a framework developed by Microsoft, which is used to build HTTP based services. It processes the information/data between two applications...

Thursday, March 5, 2020

05 Mar

Introduction to Web API

In the world of web, API is playing a big role. API stands for application programming interface. What is Web API? Web API is a framework which is used to build HTTP based services. It processes the information/data between two applications and returns the data in XML or JSON format. API can be accessed by a broad...

Saturday, January 18, 2020

18 Jan

[Solved] SQL SERVER (Error Message) : Invalid object name 'string_split'.

SQL SERVER (Error Message) : Invalid object name 'string_split'.  Error : string_splitis new built-in table value function introduced in SQL SERVER 2016. When we upgrade the Sql server current version (SQL SERVER 2014) to latest version (SQL SERVER 2016 or higher) and start using this function getting...

Sunday, January 5, 2020

05 Jan

SQL SERVER : Split comma separated string value

In this article I am going to explain how to split the comma separated string value in Sql Server. Microsoft release the Sql Server 2016 in year 2016 and introduced new built-in table value function string_split. This function can be used to split a string value by a specified separator character and returns the...

Tuesday, October 15, 2019

15 Oct

SQL SERVER : Take database backup automatically

In this article I am going to explain how to take automate daily backup of SQL Server database As you know database is the heart of any software driven application and nobody want to lose it on any cost. So the main purpose of the database backup is to create a copy of database that can be recovered if something...

Saturday, September 28, 2019

28 Sep

Windows Task Scheduler: How to Create Basic Task

Here in this post I am going to explain how to create a basic task in Windows Task Scheduler Few days ago I have wrote an article on Windows Task Scheduler. You can read this to know why we use the task scheduler. To create basic task follow the steps given below: STEP 1: Open Task Scheduler Go to windows start...
Page 1 of 8312383Next