Dr_Vafis
March 27th, 2001, 01:36 AM
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
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