Add row to query result using select or Add new row using data returned by SELECT statement

Description:

In this example we explain that how to Add row to Query result using Select statement in SQL Server. Or how to add one more row to select query result in SQL Server. Or SQL Query to add new row in Select query result in sql server. Or insert new row using data returned by SELECT statement in SQL Server.

Here we demonstrate that how to add a “Custom” row to the top of the select result set in SQL Server. Or how to append new row to the select statement using SQL Server.

Here we use the “UNION” to add one more row to the select result set. Here we have “Branch” table in which we have to add one more branch as a select result query so below is the query that demonstrate how we can add one more row to select result set.

Query:

select * from Branch

select * from Branch

union

select -1 AS [Branch ID], 'undefined' AS [Branch Name]