Retrieving Multiple Data using stored procedure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Retrieving Multiple Data using stored procedure

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-10 : 08:21:08

Thufail Ahmed writes "How to retrieve multiple data from a table using stored procedure.........."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-10 : 13:12:19

CREATE PROC SomeProc
AS

SELECT Column1, Column2
FROM Table1

SELECT ColumnA, ColumnB
FROM Table2

RETURN 0

GO

Tara

X002548
Not Just a Number

15586 Posts

Posted - 2004-06-10 : 16:03:30

Now not being an app dev anymore...(thank the lord)

That's not a good idea, or seems to be the general concensus

Just make 2 sprocs....

Brett

8-)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources