The SQL Server MERGE command is the combination of INSERT, UPDATE and DELETE commands consolidated...
SQL Server
Using Merge Into in SQL Server
Top 10 New Features of SQL Server 2017
TechAid24 - Microsoft has added many new features and functions to SQL Server 2017. Here, we will...
How To Optimize SQL Queries
In this article, we want to discuss about the efficient way to Optimize SQL Queries in SQL Server...
PIVOT and UNPIVOT in Sql Server
PIVOT is one of the New relational operators introduced in SQL Server 2005. It provides an easy...
SQL: Find a database physical location and size
I often go to database storage folder and clean up all unnecessary files I have left there taking...
Why do we need use Stored Procedure?
Stored procedure give us many advantages over using SQL scripts and SQL statements that are...
SQL: Find database file growth status
You can set database auto-growth setting by using SQL Server Management Studio, scripted SMO or by...
How to add a Linked Server in SQL Server
In this article, we discuss about How to add Linked Server in SQL Server. There are two ways to add...
How to format a Datetime value in SQL Server
In this post, we want to discuss about efficient way to convert datetime format in SQL Server...
Table type Parameters in SQL Server
This is a new feature intorduced in Sql Server 2008. Table-Valued Parameters provides option for...
Interview QA
Android Interview Questions & Answers 1
1) What is Android? It is an open-sourced operating system that is used primarily on mobile...
Android Tutorials
Variables and Data Types in Java
In short Variable is name of reserved area allocated in memory. In other words, it is a name of...
