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)
 can i use a collection object as parameter for stored procedure?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-09-23 : 08:06:25
ashwini writes "i want to have an object passed to the stored procedure which contains variables of different datatype.can i do so?
for eg consider a c++ class object

class employee{
name :string
age:long

}
can i send this object directly to stored procedure as parameter?
to send individual values is difficult if many values exists....

pls help me in this
regards
ashwini"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-09-23 : 08:07:30
Send the values as a comma-separated string, then parse them within the procedure. These links will help:

http://www.sqlteam.com/SearchResults.asp?SearchTerms=csv
Go to Top of Page
   

- Advertisement -