Create Proc Dynamic_table
@tableName varchar(50)
as
begin
declare @sql nvarchar(100)
Set @sql='Select * from '+@tableName
exec sp_executesql @sql
end
@tableName varchar(50)
as
begin
declare @sql nvarchar(100)
Set @sql='Select * from '+@tableName
exec sp_executesql @sql
end
No comments:
Post a Comment
Highly Appreciated your comments