参数@PostCode是一个逗号分隔的邮政编码字符串(仅上半部分,即邮政编码中“空格”之前的所有内容)。列[PCode]是对应的数据(即[Postcode]列中邮政编码的前半部分):FROM [database]
WHERE (PCode IN (REPLACE(@PostCode, ',', ''',
所以我的.txt文件看起来像这样:Streetnumber streetname city state zipcode使用fscanf("%s%s%s", %(ptr->name.firstname), %(ptr->name.middlename, %(ptr->name.lastname))1223West