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: 187
sql-server-2005
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