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 |
|
vnswathi
Starting Member
8 Posts |
 Posted - 2006-06-01 : 17:12:17
|
| Can any one help me with a sample code, which can take an array of elements as one of it's parameters and get the value inserted into a table in a stored procedure. Thanks in advancevnswathi. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-01 : 17:46:47
|
| What would this "array of elements" look like? What data type? How could you tell what each element was?CODO ERGO SUM |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-06-01 : 20:01:32
|
| >> Array of elementsDo a search in this forum on CSV>> Get the value inserted into a tableuse the scope_identity() function |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-02 : 01:55:18
|
| http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htmMadhivananFailing to plan is Planning to fail |
|
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
|
|
vnswathi
Starting Member
8 Posts |
Posted - 2006-06-02 : 17:05:23
|
| Thank you all, i really appreciate your help.Thanks,Swapna. |
|
|
|
|
|
|
Array in a Stored Procedure