Traditional Culture Encyclopedia - Hotel franchise - SQL statement query: Find out the city according to the address.
SQL statement query: Find out the city according to the address.
Select id and city from dbo. Trim (city) where TBL is located =' Dong Min Science and Technology Building, Qianfeng South Road, Taiyuan City, Shanxi Province 10 Floor 12'
Can't find it because there are spaces before and after the data in the city field.
-supplement.
It is out of the question. Some of you are not cities, but counties, and some are preceded by provincial names. You don't have a unified standard here, so it's hard to get it with stored procedures and simple sql.
- Related articles
- Ask for a road map to travel to Dubai
- Hequ limin grain shop business license
- Singapore Development Management Institute MDIS Singapore Management Institute SIM Swiss Lausanne Hotel Management Institute EHL read my brother and sister to help! ! !
- Address and transportation of Dali Mao Lan Inn
- How can Jinjiang Inn get to Hongqiao Railway Station?
- Kyoto travel guide free travel
- Pingdingshan Yumingyuan Hotel wifi password
- Sheraton Wuhan Hotel ¡ª¡ª Introduction of five-star Sheraton Wuhan Hotel
- Which district does Zhuge Liang Cultural Tourism Industrial Park belong to?
- What is the sales service hotline of Changchun Guoxin Nanshan Hot Spring City?