Re: Stored Procedures... - SQL Server Forums

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)

Re: Stored Procedures...

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-07 : 10:15:26

Ranga guru Cholan writes "i have to right a stored proc to select a set of records by joining atleast 7 tables... right now im using the query...but i need to do same using stored proc...

for eg,

create procedure sample
(
@inval integer,
@retval varchar[50] output
)
AS
Begin
select * from table_name
where iIn_id=@inval
End
go

lets say this return atleast 10 records... will the above proc will return all the records?...

same scenario for inserting the records....

please do help me"

Nazim
A custom title

1408 Posts

Posted - 2002-02-07 : 10:22:15

Certainly it will.

but am sure that is not your question. can you be more clear .

--------------------------------------------------------------
Dont Tell God how big your Problem is , Tell the Problem how Big your God is

andre
Constraint Violating Yak Guru

259 Posts

Posted - 2002-02-07 : 10:24:13

If you are returning records, you don't need the output parameter in the stored procedure you listed. You could get by using this:


create procedure sample
               (
               @inval int
               )
               AS

SET NOCOUNT ON
select * from table_name
where iIn_id=@inval

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources