pass table name as a parameter in stored procedure

use northwind
--Select Rows
Create proc mm(@tablename varchar(max))
as
begin
declare @tablename1 as varchar(max)
 set @tablename1 ='select * from ' + @tablename
 --print @tablename1
EXEC (@tablename1)
end
--EXEC mm Customers


--Delete Rows
alter proc DeleteDynamic(@Tablename Varchar(max),@OId Varchar(max))
As
Begin
Declare @tablename1 as varchar(max)
Set @tablename1='delete from '+@Tablename + ' Where orderId='+ @OId
Exec(@tablename1)
End
-- DeleteDynamic orders,10248

Browse More Articles

Tweet

Written by Test

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.