How about try

select ' RESTORE DATABASE ' + name + ' from ' + name + '_dat'

from sysdatabases

where name not in ( 'model', 'northwind', 'pubs','tempdb')

This will...