Why stored procedure can not set a parameter which represents a table name?
It is possible??
A example is following:
CREATE PROCEDURE Find_Max_Sn
(@tablename varchar(15),
@sn varchar(15))
AS
declare @maxsn integer
select @maxsn= max(@sn) from @tablename

@tablename parameter is not acceptable for sql server