November 2, 2007 at 3:05 pm
Hi, thanks for you time. Here is my problem. I need to write a stored proc that get info from a sql server 2005 table. Each record has multiple field, I need them all back in my visual basic app
(
@Param1 varchar (10),
@Param2 varchar (2) Output,
@Param3 varchar (20) Output,
@Param4 varchar (50) Output,
@Param5 varchar (100) Output,
@Param6 varchar (100) Output,
@Param7 varchar (50) Output,
@Param8 (50) Output,
@Param9 (50) Output,
@Param10 (50) Output
)
AS
BEGIN
SET NOCOUNT ON;
SELECT Param2,Param3,Param4,Param5,Param6,Param7,Param8,Param9,Param10
FROM tblParams
WHERE Param1 = @Param1
I know the above select statement is wrong cuz i get nothing
Please help
Thanks
Jay
November 3, 2007 at 3:07 am
Is this what you looking for....
CREATE PROCEDURE uspTest
(
@Param1 varchar (10),
@Param2 varchar (2) Output,
@Param3 varchar (20) Output,
@Param4 varchar (50) Output,
@Param5 varchar (100) Output,
@Param6 varchar (100) Output,
@Param7 varchar (50) Output,
@Param8 (50) Output,
@Param9 (50) Output,
@Param10 (50) Output
)
AS
BEGIN
SET NOCOUNT ON;
SELECT @Param2 = Param2, @Param3 = Param3, @Param4 = Param4, @Param5 = Param5, @Param6 = Param6, @Param7 = Param7, @Param8 = Param8, @Param9 = Param9, @Param10 = Param10
FROM tblParams
WHERE Param1 = @Param1
END
GO
--Ramesh
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply