What can I do if I want a table name be a parameter of a procedure?

[shanghai2004]

Hi,
I need to use bulk insert to load text files to tables. Since the tables are all in different structures, I want the bulk insert be a procedure, then I can execute the procedure in a loop by assinging different table name and text file name. But SQL does not allow me to take a database object as a parameter of a procedure, now what can I do?
Help please!

Thanks

 

[mrdenny]

You need to use Dynamic SQL to do this. Or write one procedure for each table.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)