Never mind it was some spaces that were created when I copy paste the code. I fixed and it works.

now another question when I run the stored procedure ( exec GenerateInsUpdateScript countries) isnt that suppose to generate another stored procedure and save to my database or it just display it to me????

Because It just display it to me.