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.
| Author |
Topic |
|
SteveH
Starting Member
27 Posts |
 Posted - 2006-04-18 : 14:22:23
|
| I have a simple stored proc with one input parm that gets first and last name based on an ID#. There will be a connection established to this database and sproc from a VB 2005 front end. Do I need output parms for the name fields?Thanks.Steve |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-18 : 14:30:58
|
| No, you can just output the result set using a select statement.Tara Kizeraka tduggan |
 |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-04-18 : 14:33:36
|
| U can use Output Parameters or u can avoid thatAnyhow u can get the results u expectSrinika |
|
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-04-18 : 15:54:05
|
| The output parameters come in handy if you want to have a query/stored proc grab the results from another stored procedure. Otherwise, as everyone has indicated you can just issue the select you want and the results will come back per your command.Dalton |
|
|
|
|
|
|
Is output parm needed?