Subject | Stored Procedure question |
---|---|
Author | chris_michalec <Cmich22@aol.com> |
Post date | 2003-01-22T23:21:12Z |
This may be easy, but I haven't found anything in the documentation
to point me in the right direction.
How could I pass a tablename in through a stored procedure?
Ie
Create Procedure Delete_From_Table( ATableName Char(20)) as
begin
Delete from :ATableName;
end;
I know the above doesn't work because that is what I tried, but I
think you get the idea of what I am trying to do.
Thanks,
Chris Michalec
to point me in the right direction.
How could I pass a tablename in through a stored procedure?
Ie
Create Procedure Delete_From_Table( ATableName Char(20)) as
begin
Delete from :ATableName;
end;
I know the above doesn't work because that is what I tried, but I
think you get the idea of what I am trying to do.
Thanks,
Chris Michalec