Selecting data from a table, here the table name is dynamic...
The below code doesn't work due to the dynamic table name
CREATE PROC DynamicData ( @tableName VARCHAR(100))
AS
SELECT * FROM @tableName
To overcome above limitation, we suppose to use dynamic SQL
CREATE PROCEDURE DynamicData(@tblname nvarchar(127))
AS
EXEC('SELECT *
FROM ' + @tblname + ';')
--Calling SP
EXEC DynamicData 'EMPLOYEE'
EXEC DynamicData 'DEPT'