Mandatory prompt with the data type specified

Note the following:

  • This prompt requires a valid integer value as response.
  • The DefaultText argument is not specified. Therefore, it is a mandatory prompt.
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
where COUNTRY_MULTILINGUAL.COUNTRY_CODE > 
	#prompt('Starting CountryCode',
			'integer',
			'',
			'',
	'[gosales].[COUNTRY_MULTILINGUAL].[COUNTRY_CODE]')#