Parameters 1

[drallabs]

Can you use a parameter in a stored procedure to select a table? e.g.,

create procedure pStandEditErrorCheck @standedit char(6)
as

--Check for Duplicate Standids
SELECT standid, count(*) AS Total_Duplicate_Standids
FROM @standedit--stand_edits
GROUP BY standid
HAVING count(*) > 1

return

 

[mrdenny]

No.

The only way would be to use dynamic sql to make this happen. This then gives you security issues that you would need to resolve.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

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

http://www.mrdenny.com

 

[drallabs]

is there a way to pass in any table into a batch process or stored procedure. I am attempting to build a batch/stored procedure that can take any table as input without having to hard-code in the name of the table.

 

[mrdenny]

Again, only via dynamic SQL.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

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

http://www.mrdenny.com