SQL Built-In Functions And Stored Procedures

In this stunning reassessment, Nicole T. C. Chiang argues that the famous Qianlong art collection is really ‘the collection of the imperial household in the Qianlong reign’. The distinction is signifi

During the Mao years, laughter in China was serious business. Simultaneously an outlet for frustrations and grievances, a vehicle for socialist education, and an object of official study, laughter bro

Chinese medicine has a rich history that has only been made more complex by its integration with “Western” biomedicine. Legitimization of Chinese medicine in biomedicine-dominated health systems, such

This book contains thirty-six case reports that focus on six topics that reflect the current trends in Asian copyright law―namely, digital copyright, collective copyright, criminal copyright, limits t

The history of Qing palace eunuchs is defined by a tension between the role eunuchs were meant to play and the life they intended to live. This study tells the story of how a complicated and much-mali

This work offers the most comprehensive account of the origin and consequences of the Yan’an Rectification Movement from 1942 to 1945. The author argues that this campaign emancipated the Chinese Comm

Underground Front is a pioneering examination of the role that the Chinese Communist Party has played in Hong Kong since the creation of the party in 1921, through to the present day. The second editi

The publication of this book marks the fifteenth anniversary of the outbreak of SARS epidemic in Hong Kong in 2003. This documentary study, originating as a research project a year after the epidemic,

The “ASEAN Way” is based on the principle of consensus; any individual member state effectively has a veto over any proposal with which it disagrees. Dividing ASEAN and Conquering the South China Sea

This book tells the fascinating story of the development of medical and sanitation services in Hong Kong during the first century of British rule and how changing political values and directions of th

A City Mismanaged traces the collapse of good governance in Hong Kong, explains its causes, and exposes the damaging impact on the community’s quality of life. Leo Goodstadt argues that the current we

China’s ascent to the ranks of the world’s second largest economic power has given its revolution a better image than that of its Russian counterpart. Yet the two have a great deal in common. Indeed,

Ambrose Yeo-chi King has been a pioneer since the mid-1960s theorizing China’s modernization process. China’s Great Transformation: Selected Essays on Confucianism, Modernization, and Democracy is a c

In this book, the Zhou-Yi and its Divination Process are reviewed from mathematical perspectives which provide a completely new understanding of its meaning and operation features. The highlights are:

China stands as a major “Red Swan” challenge to the social sciences. The resilience of the Communist party-state, in combination with a rapidly expanding and internationally competitive economy, chall

Meeting Place: Encounters across Cultures in Hong Kong, 1841–1984 presents detailed empirical studies of day-to-day interactions between people of different cultures in a variety of settings. The broa

Taiwan is a peculiar place resulting in a peculiar cinema, with Hou Hsiao-hsien being its most remarkable product. Hou’s signature long and static shots almost invite critics to give auteurist reading

Tracing its origins back to 1822 in Whampoa, the Mariners’ Club in Hong Kong was established to meet a specific need for an Anglo-Chinese society defined by that most dubious of activities, seafaring.

Writing academic prose in English is especially difficult for non-native speakers, largely because the standard vocabulary used in this genre can be quite different from colloquial English. Expand You

The main objective of Chinese-English Contrastive Grammar: An Introduction is to familiarize the reader with a subset of the learning difficulties and common errors in ESL/EFL pronunciation and lexico

The first of its kind, this book presents a comprehensive collection of leading patent cases from nine major Asian jurisdictions which are analyzed by eminent scholars and legal practitioners from Asi

News under Fire: China’s Propaganda against Japan in the English-Language Press, 1928–1941 is the first comprehensive study of China’s efforts to establish an effective international propaganda system

Previous scholarship on trials of war criminals focused on the legal proceedings with only tacit acknowledgement of the political and social context. Dean Aszkielowicz argues in The Australian Pursuit

Having analysed the most common English errors made in over 600 academic papers written by Chinese undergraduates, postgraduates, and researchers, Steve Hart has written an essential, practical guide

Recent discoveries of bronze ritual vessels from ancient China provide the ground for this collection of essays, which focus in particular on the nature and patterns of family lineages as seen from th

BY 1945, EVERYWHERE ONE LOOKED IN THE FAR EAST THE BRITISH EMPIRE WAS BEING OPENLY QUESTIONED OR WAS FAILING OUTRIGHT. YET IN THE PREVIOUS CENTURY, THE BRITISH HAD BEEN THE PRE-EMINENT IMPERIAL POWER

Advertising is something which we are exposed to from a young age and which can affect us in many different ways. Centered around the question “Does advertising improve society?” this volume explores

Tracing China’s journey began from exploring rural revolution and reconstitutions of community in South China. Spanning decades of rural-urban divide, it finally uncovers China’s global reach and Hong

This work is a classic in the study of twentieth-century Chinese fiction. C. T. Hsia delved into the works of important writers such as Lu Hsün, Pa Chin, Lao Shê, Eileen Chang and Ch’ien Chung-shu. In

彌敦道自北至南貫穿太子（旺角）和尖沙嘴，沿途包括地標及建築計有半島酒店、重慶大廈、九龍公園、九龍清真寺暨伊斯蘭中心、東英大廈等，是九龍市中心的大動脈。彌敦道上店舖林立，大型廣告牌縱橫交錯，交通車水馬龍，時刻都是熙熙攘攘。盧沛雄鏡頭下的彌敦道全景合成圖像（左右兩邊地舖），既親切又陌生，是長時間等候找拍的成果。「也許，我想拍下的，不只是眼前美麗的景象，而是那些不斷流逝的記憶。」二OO五年的彌敦道，今天看來會否陌生? 修訂版保留原版照片，增訂文字，見證十年來彌敦道的變化。Nathan Road is the main thoroughfare in Kowloon, Hong Kong. Running in a south-north direction from Tsim Sha Tsui to Mong Kok district, Nathan Road is lined with landmark buildings such as Peninsula Hotel, Chungking Mansions, Kowloon Park, Islamic Centre connecting the locale districts. Known to locals and tourists as a must-go local fare, its amalgamation of shops, restaurants, advertising billboards, shop signages, and transportation exchanges points with its continuous flow of traffic and people, forms an energetic street scene. Nathan Road, as hustle & bustle as it is, stages an on-going changing scene that one can’t resist revisiting occasionally before a new shop, a new advertising billboard or even a new building replacing the present.In 2005,

Kung Fu has evolved from a traditional means of defence to become a system of attacking and defending oneself, with or without weapons, exercising the body and maintaining good physical and mental hea

Bugis Street was famous (or notorious) for being a haunt of transgender prostitution in the early decades of postcolonial Singapore. Since then the site has been a source of touristic obsession and lo

Translingual Narration is a study of colonial Taiwanese fiction, its translation from Japanese to Chinese, and films produced during and about the colonial era. It is a postcolonial intervention into

MAO Zedong was a Chinese communist leader and founder of the People's Republic of China. He developed his own ideology and methodology known as Maoism or Mao Zedong Thought, and his thought has a grea

Transgender identities and other forms of gender and sexuality that transcend the normative pose important questions about society, culture, politics, and history. They force us to question, for examp

INTRODUCTIONAt a time when there is a developing ideological gap among generations and a degradation of trust between people and the institution of government, there are concerns whether young people’

INTRODUCTIONSelf-Access Language Learning (SALL) has played a prominent part in language education in universities. Its role is to foster autonomous learning among students. With the wide-spread imple

As the Opium War unfold in Guangdong Province, the painter Su Renshan (1814—c.1850) exploded onto the art scene with a bold, paradigm-turning new voice. A Defiant Brush takes a fresh look at this unde

Long before the Europeans reached the East, the ancient Chinese had elaborate and meaningful perspectives of the West. In this groundbreaking book, Wang explores their view of the West as other by loc

Tsering Woeser and Wang Lixiong are widely regarded as the most lucid, insightful writers on contemporary Tibet. Their reportage on the economic exploitation, environmental degradation, cultural destr