“dual” is a special reference in the Oracle world.
Rather than trying to solve how to “create” a dual table in SQL Server – the real question is how one achieves this sort of functionality for SQL Server.
Oracle requires a FROM clause, hence the existence of SYS.DUAL as a “dummy” table. SQL Server does not have such a requirement. Just leave off the FROM clause completely.