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 2005 Forums
 .NET Inside SQL Server (2005)
 parameter as table column values

Author  Topic 

asilter
Starting Member

5 Posts

Posted - 2007-09-21 : 06:39:45
can we define a stored procedure parameter which holds a table's column values?
And can we loop in it in a stored procedure?

If yes, could you give a little sql code sample?

Thanx

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-21 : 06:59:30
Did you mean this?
http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

asilter
Starting Member

5 Posts

Posted - 2007-09-21 : 08:53:19
no.

int the example you sent, the passing parameter is like one string which holds values seperated by commas.
what i want to learn is if sql server could support variables which are in format like recordsets?
and if so, plz a little code sample.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-24 : 02:24:30
I dont think you can send parameter like Recordset. You need to replicate that method or use temporary table inside the procedure

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -