Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can we pass/retrieve arrays?

Status
Not open for further replies.
maddog71

maddog71

Programmer
Sep 5, 2000
1
JP
I'd like to know if we can pass an array as a parameter to a stored procedure and recieve an array from that same stored procedure and if so how would you go about coding that in the stored procedure???
 
Sort by date Sort by votes
I'm not aware of an array construct within Transact SQL. You may want to look into creating a temporary table instead.

Regards...Marc
Independent Software Consultant
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
145
Chris Miller
Chris Miller
iambob
  • Locked
  • Question
Retrieve Data from Database - SQL 1
Replies
2
Views
78
TamarGranor
TamarGranor
how2trainyourdragon
  • Locked
  • Question
SQL Server 2016 to 2019 now SSRS Cannot create a connection to data source
Replies
1
Views
157
how2trainyourdragon
how2trainyourdragon
Auguy
  • Locked
  • Question
Passing Table Variable to Update Table
Replies
2
Views
128
Auguy
Auguy
xarzu
  • Locked
  • Question
In SSRS 2008, how are parameters passed down to the DatSet Query... or can they?
Replies
0
Views
63
xarzu
xarzu

Part and Inventory Search

Sponsor

Back
Top