How to dynamically create tables and table names in MSSQL2005 dynamic parameters determined by

I want to create a temporary table with the name of the machine: HOST_NAME (), and the table body is fixed. You only need to dynamically determine the table name.

How do I create a table name dynamically as the user's machine name when I create it?

I used the following sentences to prompt for errors:

Declare @TableName as char(50)
SELECT @TableName = '#temp_'+host_name()
CREATE TABLE [dbo].[@TableName](…………
）

Excuse me, is there any good way to do that? Or is it necessary to construct such a created script in the command's Commantext and execute it?

Workaround:

declare @name varchar(100)
select @name='#temp_'+replace(host_name(),'-','')
exec('create table '+@name+'(id int,col varchar(200))')