SQL Built-In Functions And Stored Procedures

An exploration of collective memory through the lens of East Asian film during World War II. Taking the "tidal wave" of memory in the late twentieth and early twenty-first century as its starting point, this monograph explores the collective memory of World War II in East Asia (1937-1945) through film. Weiss argues that Chinese, Japanese, and American remembrance of World War II is intertwined in what she terms a "memory loop," the transnational mediation and remediation of war narratives. Gender is central to this process, as the changing representation of male soldiers, political leaders, and patriarchal father figures within these narratives reveals Japanese and Chinese challenges to each other and to the perceived "foundational" American narrative of the war. This process continues to intensify due to the globally visible nature of the memory loop, which drives this cycle of transmission, translation, and reassessment. This volume is the first to bring together a collection of Chin

New research on the history of public housing and squatting in Hong Kong. In Hong Kong Public and Squatter Housing, Alan Smart and Fung Chi Keung Charles trace the development of squatting in Hong Kong from 1963 to 1985. The authors reconstruct government policy on squatting through both ethnographic and archival research. This book sheds new light on the consequences of various attempts to control encroachment on scarce urban space. The authors argue that intersecting policy agendas resulted in decisions that were often not desired, but which emerged as practical solutions from prior failures. They address the challenges of explaining confidential policy decisions and offer new approaches applicable in other contexts. Overall, this book makes an important contribution to the understanding of how public housing and squatting interacted in influential ways that have been poorly understood and offer new perspectives on the challenges of urban governance and housing problems.

How do we situate ourselves when we navigate the city of Hong Kong—physically, and in our minds? Against a backdrop of bustling density and movement, the difficulties of making space have shaped our days. From the challenges of limited living space and the quest for personal space, to the everyday negotiations of our identities in the social space, we are constantly confronted with the question: How do we redefine the distance between the city, others, and ourselves, and between the selves within us? This collection features prose, poetry and artwork from writers and artists in or from Hong Kong, as well as those who have had a close connection with the city, that explore the (im)possibility of making space. How do we remake space in our lives and our creative practices? What does this (im)possibility mean in (or in relation to) Hong Kong today?

In Daily Giving Service: A History of the Diocesan Girls’ School, Hong Kong, Moira M. W. Chan-Yeung and her fellow contributors present a comprehensive history of one of Hong Kong’s oldest girls’ schools. As an alumna of the school, Chan-Yeung traces the history of her alma mater from its establishment in 1860, to its development over the last 160 years until the recent decade. Having experienced stability and turbulences in Hong Kong in the twentieth century, the school has become one of the most prominent girls’ schools in the city. In several chapters written by other alumnae, various aspects of school life of different eras are reconstructed and remembered.The author and other contributors focused on the postwar era in which Hong Kong grew from a small city to a global metropolitan. The expansion of the Diocesan Girls’ School largely followed this trend. The history of the school has also long been connected with the socio-economic development of Hong Kong society, sharing its happ

Entanglements: Physics, Love, and Wilderness Dreams, Jack Mayer’s second poetry collection, is a poetic mélange about relationships, from sub-atomic particles to our human family; the ties that bind. Mayer, a pediatrician, poet, and hiker, explores the metaphysics of cosmology and that particularly intense entanglement, love. At the macroscopic level, Mayer’s doctor poems, inspired by his pediatric practice in rural Northern Vermont, take the reader into the heart and soul of a healer inspired to find meaning in his patients’ often difficult lives. Unique connections are unearthed. As a wilderness hiker and canoeist, Mayer has experienced the healing power of wilderness; the mystery of belonging to wilderness, of independence and interdependence. His wilderness poems carry us into his beloved Green Mountains on Vermont’s Long Trail. On solo hikes he composes poems, then copies his first draft into the nearest shelter’s logbook under his trail name, “Mountain Poet.” A durable thread con

Psychopathology: An Empathic Representational Approach retraces the foundations of classical phenomenological psychopathology and integrates them with modern ideas drawn from anthropology, cognitive neuroscience, computational science, and evolutionary biology to synthesize a comprehensive framework and provide fresh insights.This book explores how the scientific concepts of ‘information and representation’ can be used to understand subjective mental phenomena and integrate them in empathic clinical dialogues during interactions with patients. It explores key issues in clinical psychopathology coherently and systematically, illustrates advanced topics in an accessible manner using clinical case examples, metaphors and clarifying diagrams, and directly links advanced conceptual frameworks with pragmatic skills in the clinical dialogue process.This volume is aimed at a broad audience of mental health professionals, researchers, and students in psychiatry, psychology, and social work. Its

In The First British Trade Expedition to China, Nicholas D. Jackson explores the pioneering British trade expedition to China launched in the late Ming period by Charles I and the Courteen Association. While utilizing the vivid and unique perspective of its commander, Captain John Weddell, this study concentrates on the fleet’s adventures in south China between Portuguese Macao and the provincial capital, Guangzhou (Canton). Tracing the obscure origins of Sino-British diplomatic and commercial relations back to the late Ming era, Jackson examines the first episodes of Sino-British interaction, exchange, and collision in the seventeenth century. His definitive narrative and original analysis constitute a groundbreaking study of early modern British initiatives and enterprise in the coastal areas of south China. The book begins by sketching the Tudor-Stuart historical background of British trade expansion in Asia before precisely reconstructing the voyages of East India Company and then

Set against the backdrop of regional and international post–Second World War tensions, Grounded at Kai Tak is the most comprehensive account of the complex legal struggle for ownership of 71 airplanes belonging to the two main Chinese airlines, which were stranded at Kai Tak airfield in Hong Kong at the end of the Chinese civil war. The resulting contest for possession of them took place in the courts and among politicians and diplomats on three continents. In the process, the struggle became entangled with the anti-communist policies of the United States in the emerging ‘Cold War’, British hopes for restoration of her pre-war commercial position in China, disagreements between nations about recognition of the new government in Peking, and the delicate balance that the colonial government of Hong Kong had to keep to preserve that colony’s interests.Merry tells the tale of this legal saga by weaving together archival documents and news reports of the day, revealing the international ali

Essentials of Contract Drafting and Negotiation for Construction Professionals is a practical and user-friendly guide to common practical contractual matters and is intended for construction professionals involved in contract drafting and negotiating. Knowing how to draft an effective contract is crucial in construction, particularly because of the complex and technical nature of construction projects. Divided into six chapters, this guide will enhance and refresh essential knowledge for lawyers and construction professionals who need to understand the principles of drafting and interpreting construction contracts, how to clearly identify and include key elements in these contracts, as well as how to avoid legal traps and pitfalls in contract negotiations and enforcement.

Essentials of Contract Drafting and Negotiation for Construction Professionals is a practical and user-friendly guide to common practical contractual matters and is intended for construction professionals involved in contract drafting and negotiating. Knowing how to draft an effective contract is crucial in construction, particularly because of the complex and technical nature of construction projects. Divided into six chapters, this guide will enhance and refresh essential knowledge for lawyers and construction professionals who need to understand the principles of drafting and interpreting construction contracts, how to clearly identify and include key elements in these contracts, as well as how to avoid legal traps and pitfalls in contract negotiations and enforcement.

Hong Kong’s Link to the US Dollar covers the origins of the city’s currency crisis in 1983, the initial resolution of the crisis by creation of a traditional currency board, the subsequent problems leading to the Asian financial crisis of 1997–98, and the later reforms. A new final chapter traces monetary developments in Hong Kong between 2005 and 2020.This valuable compendium of articles, originally written in the bimonthly journal Asian Monetary Monitor between 1981 and 1989, includes the key article that formed the basis for the Hong Kong government’s decision in 1983 to peg the currency to the US dollar, as well as other important documents of historical record.The main contribution of the book is its detailed monetary analysis of Hong Kong’s unique financial system before and after the currency crisis of 1983. The book explains the collapse of the floating Hong Kong dollar under the pressure of capital outflows during the Sino-British negotiations (1982–84) over the future of Hong

More Than 1001 Days and Nights of Hong Kong Internment is the wartime journal of Sir Chaloner Grenville Alabaster, former attorney-general of Hong Kong and one of the three highest-ranking British officials during the Japanese occupation. He was imprisoned by the Japanese at the Stanley Internment Camp from 1941 to 1945. During his internment, he managed to keep a diary of his life in the camp in small notebooks and hid them until his release in 1945. He then wrote his wartime journal on the basis of these notes. The journal records his day-to-day experiences of the fall of Hong Kong, his time at Stanley, and his eventual release. Some of the most fascinating extracts cover the three months immediately after the fall of Hong Kong and when Alabaster and his colleagues were imprisoned in Prince’s Building in Central and before they were sent to the camp, a period little covered in previous publications. Hence, the book is an important primary source for understanding the daily operation

In New Asian Disorder: Rivalries Embroiling the Pacific Century, Lowell Dittmer and his team explore the recent political disorder in East Asia resulting from growing Sino-American polarization. The rise of China in recent years is widely regarded as a momentous shift in the global balance of power. China is now extending sovereignty into the East China Sea and the South China Sea, constructing a new set of global financial institutions and replacing “universal values” with technologically enhanced nationalism. The country’s “Belt and Road Initiative” is also tainted by the vast ambition to realize the “China Dream” within the foreseeable future. In response to China’s challenge, the United States has abandoned its “constructive engagement” policy towards the rising power and engaged in a trade war. Sino-American relations have been at a historical trough since the normalization of their relationship in the late 1970s. This book sheds new light on the current political disorder in the

The clinical practice of nephrology is intricately related to many medical disciplines and is a challenging subject for medical undergraduates and young clinicians alike. Integrated Systematic Nephrology is a clinical reference book that provides a comprehensive yet succinct and systematic coverage of topics in nephrology. This new edition has been thoroughly updated to cover recent advances in nephrology clinical practice and research, and has been expanded to include a vast array of subjects that are crucial to anyone interested in learning about the latest developments in renal medicine more broadly.This volume brings together contributions from highly experienced nephrologists, as well as leading specialists in related disciplines such as urology, radiology, pathology, and others. It is suitable for a wide audience, ranging from undergraduates, general physicians, to nephrology trainees.

Writing has always been a difficult subject to talk about, let alone writing an honest account about how one’s creative process is complicated by global lockdown and personal hardships. In Writing in Difficult Times, eleven young promising writers from Hong Kong wallow in some of their perhaps most confusing and troubling moments in life, and share their struggles. How do writers committed to crafted language maintain a dialogue with themselves? How does the dense urban living space affect creative outputs and thoughts? How do writers reflect on and evaluate gender roles, motherhood, and time? What roles does memory play in writing, if memory’s own language is not allowed to communicate? Each personal essay in this collection is available in both Chinese and English, hoping to build a timely and genuine connection with its readers, regardless of location and cultural background. Each word is a courageous sharing that makes a significant contribution to bilingual Hong Kong literary writ

The purpose of this book is to explain both the historical context and current practices of land administration in Hong Kong. Although Hong Kong has an open and business-friendly environment, it is underpinned by a socialist leasehold land tenure system. The government is landlord to virtually all land and so it plays a pivotal role in the administration of this scare, and therefore, valuable resource.As land administration is governed by private contract law rather than legislation, it is constantly evolving with the courts handing down significant decisions on a regular basis. Government practice has to respond to this, as well as the community’s concern on how best land can be administered. The fifth edition has some substantial and important updates which should continue to be useful to both students and practitioners of surveying, architecture, planning and law, as well as the wider business and financial community.

Amidst the reshaping of Hong Kong’s social, cultural, political and ideological landscape, how do we reenvisage a city that exists in our memories? For those who have left their hometown―or the place they once called home―the question, “What does it mean to be a Hongkonger?” marks a constant shift between conflicting realities, identities and perceptions. Beyond the act of remembering, how do we reimagine our relationship with Hong Kong in the present and the future? In this collection of prose, poetry and photography by eighteen writers and artists, we see a gathering of reflections on the profound changes and subtle transitions that have transpired in Hong Kong, both in recent times and over the past decades.

In Hong Kong’s Last English Bishop, Philip L. Wickeri explores the life and times of John Gilbert Hindley Baker, who served as Bishop of the Anglican Diocese of Hong Kong and Macao from 1966 to 1981. Baker lived through exciting times, as a missionary in wartime and revolutionary China, as a priest in America during the early years of the Cold War, and as a mission leader in the Church of England when churches in many parts of the world were becoming independent, before returning to Hong Kong where he was elected bishop. He was a faithful correspondent and a prolific writer throughout his life, offering a personal commentary on the churches and the societies in which he lived. Wickeri has made extensive use of Baker’s writings and other archival materials to provide a vivid picture of his life and work. Bishop Baker was instrumental in working for reconciliation after the 1967 riots, expanding the work of the diocese, and engaging Hong Kong with the wider world. In 1971, he opened a ne

When discussing inequality and poverty in Hong Kong, scholars and politicians often focus on the failures of government policy and push for an increase in social welfare. Richard Wong argues in this b

Salon Salon unfolds a narrative about Beijing’s art scene in the decade from the late Cultural Revolution to the beginning of the Reform and Opening-up period. It focuses on the continuous influence o

Text, Cases and Commentary on the Hong Kong Legal System covers all the topics encompassed in the syllabus for “Hong Kong Legal System”, as required for the Hong Kong Conversion Examination for PCLL A

In the Book and Sword, Louis Cha revives the legend about the great eighteenth-century Manchu Emperor Qianlong which claims that he was in fact not a Manchu but a Han Chinese as a result of a "baby sw

The University Museum and Art Gallery (UMAG) of the University of Hong Kong presents the Chinese painting exhibition Tradition to Contemporary: Ink Painting and Artistic Development in 20th-century China. The exhibition is curated from artworks within the museum’s permanent collection. Works trace the evolution of ink painting in Hong Kong, and include many of the masters that have helped to build the city’s art scene and museum collections. The exhibition and its associated catalogue offers audiences a broad overview of the provenance and aesthetic quality of individual works, and the cultural interactions among twentieth-century Chinese artists, curators, collectors and scholars in Hong Kong, mainland China and abroad. 香港大學美術博物館展出中國繪畫展覽《鑑古賞今：二十世紀中國的水墨與藝術發展》。是次展覽展示博物館的永久館藏。作品追溯了香港本土水墨畫的演變，當中包括多位協助建立起城市藝術風采和博物館藏品的大師。是次展覽和出版的圖錄讓觀眾綜覽個別繪畫作品的來源和美學特質，並香港、中國內地及海外的二十世紀中國藝術家、策展人、收藏家及學者之間的文化交流。

The Cosmopolitan Dream presents the broad patterns in the transformations of mainland Chinese masculinity over recent years, covering both representations (in film, fiction, and on television) and the

This is the first book-length study of the development of civility in Chinese societies. Although some social scientists and political philosophers have discussed civility, none has defined it as an a

The personal stories of the Gao villagers demonstrate and are related to changes in China.This is a close study of Gao Village twenty years after the author, an anthropologist and native of Gao villag

In Paths of Justice, Johannes Chan illuminates fundamental themes and basic values in Hong Kong’s legal system by using his own experience and drawing on interesting and important cases. The book expl

Bosshard in China offers a comprehensive sweep of black and white photographs and documentary films produced by Swiss photojournalist Walter Bosshard. Living and travelling extensively in China from 1

Porcelain, with its fine white body, delicately painted decoration and associations with China’s culture and vast wealth, has long delighted and captivated people in the West, as well as across the wh

Construction Contract Essentials in Hong Kong is written with construction professionals in mind. By incorporating information from eminent arbitrators and construction law experts, this book offers h

Construction Contract Essentials in Hong Kong is written with construction professionals in mind. By incorporating information from eminent arbitrators and construction law experts, this book offers h

This is a guide for professionals in real estate development in Hong Kong. This third edition provides an account of the concepts of the use and change in use of land, followed by an outline of the pr

This is a guide for professionals in real estate development in Hong Kong. This third edition provides an account of the concepts of the use and change in use of land, followed by an outline of the pr

If twenty-first-century urbanization is understood as a problem, its regional epicenter is the cities in Asia. Facing unprecedented diversity in scale, scope, and environmental dynamics in the Asian u

Understanding English Homonyms: Their Origins and Usage explores the phenomenon of homonyms in English by analysing a selection of those with the most interesting histories. This book not only illustr

If twenty-first-century urbanization is understood as a problem, its regional epicenter is the cities in Asia. Facing unprecedented diversity in scale, scope, and environmental dynamics in the Asian u

The first half of the twentieth century was fraught with global tensions and political machinations. However, for all the destruction in that period, these geopolitical conditions in Manchuria cultiva

Reshaping the Boundaries: The Christian Intersection of China and the West in the Modern Era brings new material and new insight to deepen our understanding of the multilayered, two-way flow of words,

This book seeks to engage Chinese philosophy to reframe existing Western scholarship in the fields of gender, body, and aesthetics. The assembled essays cover traditional and current global issues rel

The Cold War was a distinct and crucial period in Hong Kong’s evolution and in its relations with China and the rest of the world. Hong Kong was a window through which the West could monitor what was