January 27, 2007 at 11:39 am
Hello everyone, i want to make a SP in SQL Server 2000, but without passing the parameters, i want to make a SP by using Arrays.i have the following requirements:: I have a tbale say Table 1 with 5 columns , may be one client want to get data but only req 1,3,and 5 column, other client need the all 5 ones, someone may be need the one or may be at someother time , i add new columns in Table 1 , so i dont want to pass parameters as after inserting new columns , i have to make changes in my SPs also, so i want to use Arrays as i read Databases has its own name for each columns and its knows Col1 means Column1 of Table 1.
i have no experience of wokring with arrays in SPs, kindly give me some good links or materials for this and plz explain me with a example also.
its really urgent.plz help me
Thanx in Advance.
January 27, 2007 at 10:55 pm
How to pass a list of values or array to SQL Server stored procedure?http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm
How do I simulate an array inside a stored procedure?http://databases.aspfaq.com/database/how-do-i-simulate-an-array-inside-a-stored-procedure.html
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply