Multiple select queries on multiple tables in sql stored procedure

damuhame...

SOLVED CLOSED ACTIVE ANSWERED
User: damuhameed
Posted: on Apr 25, 2013 05:35 AM
Forum: SQL Server
Answer: 1
Views: 3507

can we use single stored Procedure to execute multiple select commands to select values from multiple table and store all the tablevalues in a single dataset.?can anyone provide the sample SP of wat i said above?

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Apr 25, 2013 05:49 AM
Report

Just write as many queries as you want

CREATE PROCEDURE MySP

AS
BEGIN
	select col1, col2 from table1
	select col1, col2  from table2
END
GO

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Multiple select queries on multiple tables in sql stored procedure

Company

Explore

Follow us

Contact Us