Foreach in sql with static data

Posted by phenevo on Stack Overflow See other posts from Stack Overflow or by phenevo
Published on 2010-06-02T11:21:59Z Indexed on 2010/06/02 11:23 UTC
Read the original article Hit count: 188

Filed under:

Hi,

I have 3 tables:

Countries:

Code, Name

Vacances:

id(autoincrement),CountryCode, NameOfCountry, numberOfdays

How to foreach country insert Row:

countryCode,'Welcome in " + nameofCountry +"!",12

© Stack Overflow or respective owner

Related posts about sql-server-2005