SQL Built-In Functions And Stored Procedures

Colonial powers in China and northern Vietnam employed the built environment for many purposes: as an expression of imperial aspirations, a manifestation of supremacy, a mission to civilize, a re-crea

Harbin to Hanoi examines the relationship between the urban built environment and history of colonialism and imperialism on the China coast from 1840-1940. This multidisciplinary study brings together

Feng Shui is a Chinese wisdom in knowledge and experience related to the built environment, which has accumulated over more than three thousand years. This book as a primer to a scientific study of th

The major difficulties facing professionals in real estate development in Hong Kong involve the use and development intensity of land, the complicated procedures and the mass of building laws. This bo

The major difficulties facing professionals in real estate development in Hong Kong involve the use and development intensity of land, the complicated procedures and the mass of building laws. This bo

This book is a thorough documentation of tectonics in the Hong Kong construction industry. It looks at how buildings have been designed and built in a high-density city in a subtropical climate. Writt

This dissection manual contains detailed descriptions and allinclusive illustrations on the full range of surgical procedures in the head and neck. It also includes meticulous dissection technique gui

Countless Chinese villages have been engulfed by modern cities. Gone are the picturesque farms and feng shui groves; in their place stand high-rises built so close together that they are known as "kis

How did terms like "Asia," "Eurasia," "Indochina," "Pacific Rim" or "Australasia" originate and evolve, and what are their connections to the built environment? In addressing this question, Architectu

The small city of Macao — formerly a Portuguese colony, now a Special Administrative Region of China — liberalised its gaming industry in 2002. Since then a score of new casinos have been built and mi

Hong Kong's oldest Western cemetery garden is located in Happy Valley. This history and tour highlights the need for urgent action to conserve the built and natural heritage resources of this importan

This book is the first comprehensive treatment of the spread, acculturation, functions and evolution of English in Asia. It discusses all major issues resulting from the introduction of English in cul

This book is the first comprehensive treatment of the spread, acculturation, functions and evolution of English in Asia. It discusses all major issues resulting from the introduction of English in cul

This book describes a three-year research project which built on students’ learning experience, and addresses the issue of individual differences in mainstream primary schools in Hong Kong. The Learni

This book provides crucial reading for students and researchers of world Englishes. It is an insightful and provocative study of the forms and functions of English in Asia, its acculturation and nativ

This book provides crucial reading for students and researchers of world Englishes. It is an insightful and provocative study of the forms and functions of English in Asia, its acculturation and nativ

1960s and 1970s, within the fields of biology, psychology, and neurology are findings that advance our knowledge of how the mind functions, with special attention to social behavior. Donald Munro’s fo

A pioneering and comprehensive study of recent Malaysian cinema. Malaysian Cinema in the New Millennium offers a new approach to the study of multiculturalism in cinema by analyzing how a new wave of filmmakers champion cultural diversity using cosmopolitan themes. Adrian Lee offers a new inquiry of Malaysian cinema that examines how the "Malaysian Digital Indies" have in recent years repositioned Malaysian cinema within the global arena. The book shines a new light on how politics and socioeconomics have influenced new forms and genres of the post-2000s generation of filmmakers and provides a clear picture of the interactions between commercial cinema and politics and socioeconomics in the first two decades of the new millennium. It also illustrates how the Malaysian Digital Indies functions as a site for questioning and proposing a new national identity in the era of advanced global capitalism and new Islamisation.

Adaptive reuse refers to reusing an old building for a purpose other than which it was originally built or designed. This conservation approach has become increasingly popular around the world. Howeve

Step into a Burmese temple built between the late seventeenth and early nineteenth centuries and you are surrounded by a riot of color and imagery. The majority of the highly detailed wall paintings d

Wong Man Tat had built a solid foundation in Western painting before he became a disciple of the Lingnan master Chao Shao-an. After retiring as a primary school principal, he taught painting in the Li

Will the rise of China change the international system built by the industrial and constitutional democracies of the West of the past centuries? Should China be content with the maintenance of that sy

The forts built from the early seventeenth century onwards, the ships that defended Macau’s waters, the weapons that armed the facilities and the soldiers and sailors who manned them all are carefully

The forts built from the early seventeenth century onwards, the ships that defended Macau’s waters, the weapons that armed the facilities and the soldiers and sailors who manned them all are carefully

In Man in a Hurry: Murray MacLehose and Colonial Autonomy in Hong Kong, Ray Yep explores the latest available archival materials and re-examines MacLehose’s pivotal governorship in Hong Kong (1971–1982). MacLehose arrived in the challenging 1970s, when there were expectations for social reforms, uneasiness in the relationship between Hong Kong and London, and the 1997 factor looming large. The governor successfully carried out various social reforms and he also handled various major issues, including the anti-corruption campaign, the Vietnamese refugee crisis, and the granting of land lease of the New Territories beyond 1997. Yep unveils the tension and bargaining between the British government and explains how interest of the colony could asserted, defended, and negotiated. This book is an important study of Hong Kong’s ‘golden years’ when the city’s economy took off. It is a significant contribution to our understanding of how local autonomy was defined.

Case studies from contemporary Asia on the intersection of nature and urban spaces. Two processes are currently unfolding in diverse patterns across contemporary Asian cities: the displacement of nature in urban spaces, as well as the reimagining of nature's place in the urban sphere. The rapid urbanization of Asia has provoked contentious debates and novel schemes about the role of nature in cities. Contributors to this volume gather case studies from across Asia to address projects of urban greening and other models for the integration of nature in urban life. The book also illustrates how the intersection of urban growth and urban nature is a sector rich with fresh ideas about urban planning, governance, and social life as debates and efforts to recover nature in the city provoke moral and ethical evaluations of the human ecology of city life.

Merchants were central to the huge growth in China’s foreign trade and contributed to the development of world markets and networks. Merchants of Canton and Macao: Success and Failure in Eighteenth-Ce

This volume covers modern and contemporary forms of humour in China’s public and private spheres, including comic films and novels, cartooning, pop songs, internet jokes, and advertising and education

How do Chinese societies approach humour in personal life and in the public sphere? This book addresses the etymological difficulties of "humour" as a concept in Chinese language and explores connecti

Globalization euphoria and enthusiasm for the West are on the decline in contemporary China. Critical voices make themselves heard in artistic and cultural circles, turning towards their personal ever

Art, politics, and commerce are intertwined everywhere, but in China the interplay is explicit, intimate, and elemental, and nowhere more so than in the film industry. Understanding this interplay in

Art, politics, and commerce are intertwined everywhere, but in China the interplay is explicit, intimate, and elemental, and nowhere more so than in the film industry. Understanding this interplay in

The essays in this collection cover topics relating to the history of marathon running in Hong Kong and Asia, what role gender difference plays in marathon sport performance, and the experience of org

In this study of the anti-colonial riots which erupted in Hong Kong in May 1967, the authors of May Days in Hong Kong shed new light on their causes, their impact on future government policy and on Si

This book offers a broad overview of research and practice in professional discourse. Major developments and future directions based on current strengths are highlighted. In view of the growing intere

Practical Obstetrics and Gynaecology, Second Edition is an essential undergraduate textbook in obstetrics and gynaecology for Hong Kong medical students. It provides a comprehensive overview of all the topics in the core curriculum of obstetrics and gynaecology. In addition to the description of various diseases, there is also discussion on the evidence-based approach to the differential diagnosis and management of common symptoms/presentations in obstetrics and gynaecology. Where appropriate, flow charts and diagrams are used to help readers to make a diagnosis. The book also includes updated information on diseases that are more common in Asia. While this book is mainly written for medical students, it is also a useful basic reference for student midwives, practising doctors, and other healthcare professionals who are involved in women’s healthcare.

Simply keeping the mind clear and calm was, for many post-Tang Daoists, the path to eternal life and freedom. Through sheer serenity, practitioners believed they could attain immunity to hunger, eliminate sexual function, suspend breath and pulse, engage in astral travel, and command spirits and natural forces.In his meticulously researched study, Stephen Eskildsen examines how this perspective informed Daoist internal alchemists after the Tang dynasty (618–907), including prominent representatives of the Quanzhen tradition in the north and the Nanzong in the south. Drawing on a wide array of textual sources, he analyzes the teachings of figures like Qiu Chuji (1143–1227), Yin Zhiping (1169–1251), Zhang Boduan (ca. 984–1082), Bai Yuchan (1194– 1229), Li Daochun (fl. 1288–1292), Yu Yan (ca. 1253–1314), and Wu Shouyang (1574–after 1641), among others. These adepts emphasized passive, straightforward methods that they believed gave rise to spontaneous psychic, sensory, and physiological p

In 2018, authorities in Hong Kong seized a shipment from smugglers that contained 88 dead pangolins. Where did these animals come from, and why were they killed? Where were they going? Who was responsible? In classic true crime fashion, the book examines evidence, suspects, and legal perspectives related to this specific case and, through it, the plight of pangolins globally. The chapters detail the lives and natural history of pangolins across Africa and Asia while exploring clues that may reveal who is responsible for the endangerment of the species. The book also explores speculation surrounding the possible role of pangolins in the emergence of COVID-19 and, more broadly, the relationship between wildlife trade and zoonotic disease. The resulting tale is one of conservation researchers, public health experts, and global organizations across Asia, Africa, North America, and Europe fighting to create a world in which pangolins can thrive again.

China’s remarkable journey from poverty to becoming the world’s second-largest economic power is marked by extraordinary urban growth and consumption capacity of its urban population. Central to this development fervor are multifunctional commercial complexes and shopping malls, now key features of modern urban districts. The concept of shopping malls, originally introduced to China by American architects in the 1980s, has since flourished on an even larger scale than their American counterparts.This book delves into the origins of shopping mall development in the United States after World War II, tracing how American architects exported this building type into China’s rapidly evolving urban landscapes, particularly in Beijing, Shanghai, Chengdu, Kunming, and Guangzhou. Using primary sources, statistical analyses, and illustrated case studies, the book explores the evolution of shopping malls as a consequence of China’s profound economic, social, and cultural change over the past four

Tracing the global echoes of China sounds, mapping a new auditory history of migration, diaspora, and modernity.Tracing the global journeys of Chinese sounds from the nineteenth century to the present, this volume charts a vast sonic territory: from Cantonese opera arias in San Francisco to the “Far East sound” that shaped Jamaican reggae, and from the melodies of pigeon whistles over Germany to the revolutionary anthems of Cold War Italy… How have these sounds—traveling via migration, media, and diplomacy—been heard, adapted, or even rejected in disparate cultural landscapes?Through seventeen case studies spanning Asia, the Americas, and Europe, the book uncovers the myriad ways sounds interpreted as “Chinese” are transformed, contested, and imbued with new meanings as they reverberate across geopolitical and cultural borders. This collection provides a novel auditory history of China’s global entanglements, offering a comparative lens to understand the dynamic role of sound in transn