Stored Procedure to return record from multiple Database Table in SQL Server

Hi irshad1231,

Check the below sample query.

Database

For this example I have used of Northwind database and Test database.

You can download Northwind database using the link given below.

Download Northwind Database

Test database have the table Customers with the schema as follows.

I have already inserted few records in the table.

You can download the database table SQL by clicking the download link below.

Download SQL file

SQL

CREATE PROCEDURE SelectMutipleTable
AS
BEGIN
    SELECT TOP 5 CustomerID,ContactName,Country FROM [Northwind].[dbo].[Customers]
    SELECT CustomerID,Name,Country FROM [Test].[dbo].[Customers]
END

Screenshot