Prompt that adds text before the syntax
Note the following:
- This example uses the
TextFollowing
argument.
select
COUNTRY_MULTILINGUAL.COUNTRY_CODE as COUNTRY_CODE,
COUNTRY_MULTILINGUAL.COUNTRY as COUNTRY,
COUNTRY_MULTILINGUAL."LANGUAGE" as LANGUAGE1,
COUNTRY_MULTILINGUAL.CURRENCY_NAME as CURRENCY_NAME
from
gosales.gosales.dbo.COUNTRY_MULTILINGUAL COUNTRY_MULTILINGUAL
#promptmany('Selected CountryCodes',
'integer',
' ', // < = = this
is a space
'where COUNTRY_MULTILINGUAL.COUNTRY_CODE IN
( ',
'',
')'
)#