Blog

How to tech guides and tutorials

How To Compare Table Data And Detect Changes In SQL Server

Recently, I was working on a problem scenario where i need to maintain the histories of the table row data if any updates occurs to a row in the table. And histories maintenance should be maintained only if any data change is there while updating a table row. This post is demonstrate how the same Read more about How To Compare Table Data And Detect Changes In SQL Server[…]

How to get IDENTITY values on Multi-Rows insertion in SQL Server

In general problem scenario, we need to capture the IDENTITY value after insertion operation in a table. This is achieved by using SCOPE_IDENTITY(), @@IDENTITY and IDENT_CURRENT() function. The above functions doesn’t works in case of multi-rows insertion. SQL Server 2005 introduced the OUTPUT clause as part of INSERT statement which we can use to capture IDENTITY  values on multi-rows insertion. Problem Scenario Read more about How to get IDENTITY values on Multi-Rows insertion in SQL Server[…]

How To Import Data From Excel Sheet Into A SQL Server Database using C#

Recently I was working on project where I was given huge set of master data in a excel file which i had to migrate to the database. Generally I used to prefer some migration tools for such task like Talend but unfortunately the software was not installed on my system because of recent formatting of Read more about How To Import Data From Excel Sheet Into A SQL Server Database using C#[…]

Top 15 .NET Framework Interview Questions and Answers

.Net Framework is the most widely used framework for developing the applications on windows. It supports multiple languages such as C#, VB .Net, C++, Perl, etc. to develop applications. The following section consists of top 20 interview questions with answers related to .Net framework. Most Popular .Net Interview Questions and Answers Given below is the list of Read more about Top 15 .NET Framework Interview Questions and Answers[…]

How a .NET application is Executed?

.NET framework is most popular for build different kind of windows application. In this post, we will explain how a .NET application is executed. The way .NET applications are executed is a little bit different. The below diagram shows how a .NET application is executed. The .Net framework supports many languages(C#, VB.NET, C++/CLI,F# etc.) to Read more about How a .NET application is Executed?[…]

How to kill the process running on any specific port in windows?

In this post, we will look at how can we kill a process running on any specific port in windows. If you are a developer, then often, you would have found this error message: Port 80 in use by “Unable to open process”! Follow the below steps to kill the process. Step 1 : Start command Read more about How to kill the process running on any specific port in windows?[…]

How To Drop Multiple Databases In SQL Server

During development, Developer generally create a bunch of temporary databases that you probably do not want to keep in the database for long term. Most DBAs drop at a time using either a single DROP statement or SSMS. This post explains how we can drop multiple databases in a single query. To drop multiple database we Read more about How To Drop Multiple Databases In SQL Server[…]

What is Chrome Option in Selenium?

1. ChromeOptions in Selenium which will help to manage options like (browser in headless mode, disable info bar, add Extensions, setBinary, Load default or custom profile) to Chrome Driver. 2. ChromeOptions class extends MutableCapabilities. 3. If you want to pass any capabilities, try to use ChromeOptions. Ex.1.  Chrome Automation Info-bar            ChromeOptions Read more about What is Chrome Option in Selenium?[…]

Why Robot framework in Selenium?

Why to use  Robot Class? Because Selenium  is unable to Interact with operating system pop-ups or .exe Application So,Whenever there is a need to control keyboard or mouse to interact with OS windows like Download pop-up, Alerts, .exe applications like Notepad,Calculator, etc. Its required to use   “Robot  Class”. It helps in downloading/uploading of file. Robot  Class Read more about Why Robot framework in Selenium?[…]

Create a selenium java Framework and Project.

Readers can directly use this framework, this is compatible with all types of framework. You can download the framework using following link: https://drive.google.com/open?id=1B4ASNArSaUo8p4tB-Hf6959K0pBL5bta Create a Sample selenium java Framework and Project.    Step 1. Install TestNg Using Eclipse Marketplace.  Step 2. Go To                 File-> New -> Other -> -> Maven ->Maven Project -> Click Next Read more about Create a selenium java Framework and Project.[…]