I want to insert a record in some tables using a simple stored procedure.My question is: do i have to write several inserting procedures (one for each table) or is it possible that i can pass as a variable the name of the table in which i want to insert the reccord?i've tried to do the latter but it didn't work...is there any way? or should i write one procedure for each table?
libathos
0
Light Poster
Recommended Answers
Jump to PostConsidering each table has a different range of columns and data types a stored procedure for each is probably required. If you could use the same insert procedure to insert the same data into several tables that begs the question of why you have these others tables in the first …
All 6 Replies
hericles
289
Master Poster
Featured Poster
rch1231
169
Posting Shark
libathos
0
Light Poster
libathos
0
Light Poster
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
smantscheff
commented:
Great! I didn't know this can be done.
+11
libathos
0
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.