The ‘Computer programming’ Archives
Posted November 18, 2018 by

How To Use DROP IF EXISTS in SQL Server

How To Get Last Identity Inserted Value In SQL Server

SQL Server 2016 edition has included an awe-inspiring feature in Database engine that is DROP IF EXISTS along with a bunch of superior features. Option DROP IF EXISTS is used when we need to verify if an object exists in a database before creating/ dropping it. In this situation, we need to first drop existing […]

Posted July 20, 2018 by

How to make use of your old computer

For many years, computers have played an important role in our lives, regardless if we use them for work or entertainment. People that made an upgrade and bought a new computer recently it is very likely that their old computer has started to gather dust stored somewhere.

Category Hardware

Posted July 4, 2018 by

How to find the right computer for you

Regardless if you are buying a new computer for the first time or the 100th, picking the right computer if crucial decision. The reason for that is because you pay once for a piece of hardware that you intend on using more than a few days, so naturally you’d want to get something that would […]

Category Hardware

Posted March 10, 2018 by

How to calibrate a battery on a laptop

In today’s era, laptops play an essential role in our daily lives. They are basically a desktop PC with a built in monitor and it runs on batteries. Which is basically the reason for this tutorial.

Category Hardware, Windows

Posted March 8, 2018 by

How to protect your PC from Meltdown and Spectre

Last time we spoke about one of the biggest flaws in the past two decades. Those flaws lead to two exploits that are called Meltdown and Spectre.

Posted March 6, 2018 by

What is Meltdown and Spectre

One of the biggest new in the tech industry in recent years was a discovery in a security flaws in the processors on the devices that we use daily. The security flaws named Meltdown and Spectre design flaws (hardware design) that can be exploited on every desktop, laptop, tablet or phone that has a processors […]

Category Hardware

Posted June 26, 2017 by

Performance Tip: Avoid Using the SP_ Prefix in Stored Procedures

How To Get Last Identity Inserted Value In SQL Server

Database developers often name stored procedures with the SP_ prefix in SQL Server. The SP_ prefix helps other developers quickly identify an object as a stored procedure. Although there have been many debates over whether or not user created objects should be named with the sp_ prefix following the naming convention standards, we should not […]

Posted June 20, 2017 by

Execute WITH RESULT SETS Feature in SQL Server

How To Get Last Identity Inserted Value In SQL Server

With the introduction of SQL Server 2012, a useful feature was included: EXECUTE WITH RESULT SETS. This feature allows us to modify the column names and column data types of the result sets returned by a stored procedure without actually modifying the stored procedure code.

Posted June 5, 2017 by

Creating an Index with DROP_EXISTING = ON in SQL Server

Creating an index in SQL Server is a moderately simple task that improves the query performance. We can create a clustered as well as a non-clustered index which can be either unique or non-unique as per requirement.

Posted May 29, 2017 by

How to Use the TRY_CAST Function in SQL Server

How To Get Last Identity Inserted Value In SQL Server

The TRY_CAST function in SQL Server is used to cast value from its existing data type to a specified target data type. This occurs only if the operation is successful. It returns NULL if the conversion fails. TRY_CAST is an extended version of the CAST function. This tutorial explains how to use TRY_CAST in SQL […]

Posted March 6, 2017 by

SET ANSI_NULLS (ON | OFF) in SQL Server

The ANSI_NULLS database SET option controls the behavior of Equal (=) and comparison operators (!=) in queries while dealing with NULL records. It is an ISO standard to decide for a query action to conclude how SQL Server should handle the comparison with NULLs.

Posted February 28, 2017 by

SET CONCAT_NULL_YIELDS_NULL in SQL Server

How To Get Last Identity Inserted Value In SQL Server

How often do we think of NULL values while concatenating NULLs with string values? String concentration with NULL values can give us some unexpected results if we are not aware of CONCAT_NULL_YIELDS_NULL database SET options. CONCAT_NULL_YIELDS_NULL options control whether concatenation results shall be treated as NULL or empty string values.