Create table name dynamically in SQL server
This blog show the simple example to create dynamically table name in sql server
Write this query and get table name append with current date
CREATE proc createtable
as
begin
DECLARE @SQLString NVARCHAR(MAX)
SET @SQLString = 'CREATE TABLE Tab_'+convert(varchar,getdate(),112) + '( id bigint,name varchar(200))'
EXEC sp_executesql @SQLString
end
output :