A simple
Google search[
^] would have told you what's wrong.
Yes, SQL do not support executing a statement in an Insert statement.
There are many ways to achieve what you want. The Google link has lots of discussion which already discusses the solution.
Check them out and let us know if that doesn't help.