Blog

How to tech guides and tutorials

How I Passed 70-761 Exam: Querying Data with Transact-SQL – Microsoft?

Saturday (18th May 2019) I went through the 70-761 Exam and passed it. This post is all about the how I planned and passed 70-761 exam with details analysis of the exam. I was looking for an opportunity to check skills on SQL Server. My Senior suggested me to go for 70-761 Microsoft certification. I Read more about How I Passed 70-761 Exam: Querying Data with Transact-SQL – Microsoft?[…]

What Does “SET ANSI_NULLS ON” Mean In SQL Server ?

Most of us would have seen mentioning “SET ANSI_NULLS ON | OFF” setting at the start of a stored procedure, function etc. Lets understand why we keep that always. ANSI_NULLS is simply a setting that controls the behavior of the Equals (=) and Not Equal To (<>,!=) comparison operators when they are used with null Read more about What Does “SET ANSI_NULLS ON” Mean In SQL Server ?[…]

Cannot schema bind view ‘ViewName’ because name ‘TableName’ is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.

Are you trying to create a view with SCHEMABINDING Option and getting error like “Cannot schema bind view ‘ViewName’ because name ‘TableName’ is invalid for schema binding……” When we create view with SCHEMABINDING it is necessary to specify the schema name in objects name of SELECT statement otherwise it throw errors. For Example : 1 Read more about Cannot schema bind view ‘ViewName’ because name ‘TableName’ is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.[…]

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[…]