November 20, 2001 at 3:31 pm
hi
can anyone help.
I am new to the SQL Server.
I need to input data into a column with the PK (Primary Column) From other 2 tables
I am using a stored procedure to store the data.
Table1
NameIDFirstName LastName
1SamSmallwood
Table2
IDNamesofCD
1CD1
2CD2
Table3
NameIDID
12
11
In Real time the Person Sam Smallwood will have more than 2 CD.
In order to create the stored procedure i dont know how many variables to declare in the stored procedure.
I like to know where there is a array datatype in SQL or tell me how to a create a stored procedure with infinite variables
November 20, 2001 at 7:19 pm
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy