try using sp_executesql

By the way varchar(100) is not sufficient you need more.

Also sp_executesql  requires a nvarchar

create procedure mype

as

  DECLARE @a nvarchar(200)

  set @a= 'create table #mytable ( itemcode varchar(15),itemname...