SQL Built-In Functions And Stored Procedures

This textbook is intended for use in a course for undergraduate students in biology, neuroscience or psychology who have had an introductory course on the structure and function of the nervous system. Its primary purpose is to provide a working vocabulary and knowledge of the biology of vision and to acquaint students with the major themes in biological vision research. Part I treats the eye as an image-forming organ and provides an overview of the projections from the retina to key visual structures of the brain. Part II examines the functions of the retina and its central projections in greater detail, building on the introductory material of Part I. Part III treats certain special topics in vision that require this detailed knowledge of the structure and properties of the retina and visual projections.

Play takes up much of the time budget of young children, and many animals, but its importance in development remains contested. This comprehensive collection brings together multidisciplinary and developmental perspectives on the forms and functions of play in animals, children in different societies, and through the lifespan. The Cambridge Handbook of Play covers the evolution of play in animals, especially mammals; the development of play from infancy through childhood and into adulthood; historical and anthropological perspectives on play; theories and methodologies; the role of play in children's learning; play in special groups such as children with impairments, or suffering political violence; and the practical applications of playwork and play therapy. Written by an international team of scholars from diverse disciplines such as psychology, education, neuroscience, sociology, evolutionary biology and anthropology, this essential reference presents the current state of the field

Play takes up much of the time budget of young children, and many animals, but its importance in development remains contested. This comprehensive collection brings together multidisciplinary and developmental perspectives on the forms and functions of play in animals, children in different societies, and through the lifespan. The Cambridge Handbook of Play covers the evolution of play in animals, especially mammals; the development of play from infancy through childhood and into adulthood; historical and anthropological perspectives on play; theories and methodologies; the role of play in children's learning; play in special groups such as children with impairments, or suffering political violence; and the practical applications of playwork and play therapy. Written by an international team of scholars from diverse disciplines such as psychology, education, neuroscience, sociology, evolutionary biology and anthropology, this essential reference presents the current state of the field

Interest in political theology has surged in recent years, and this accessible volume provides a focused overview of the field. Many are asking serious questions about religious faith in secular societies, the origin and function of democratic polities, worldwide economic challenges, the shift of Christianity's center of gravity to the global south, and anxieties related to bold and even violent assertions of theologically determined political ideas. In fourteen original essays, authors examine Christian political theology in order to clarify the contemporary discourse and some of its most important themes and issues. These include up-to-date, critical engagements with historical figures like Augustine, Thomas Aquinas, and Immanuel Kant; discussions of how the Bible functions theopolitically; and introductions to key movements such as liberation theology, Catholic social teaching, and radical orthodoxy. An invaluable resource for students and scholars in theology, the Companion will al

Interest in political theology has surged in recent years, and this accessible volume provides a focused overview of the field. Many are asking serious questions about religious faith in secular societies, the origin and function of democratic polities, worldwide economic challenges, the shift of Christianity's center of gravity to the global south, and anxieties related to bold and even violent assertions of theologically determined political ideas. In fourteen original essays, authors examine Christian political theology in order to clarify the contemporary discourse and some of its most important themes and issues. These include up-to-date, critical engagements with historical figures like Augustine, Thomas Aquinas, and Immanuel Kant; discussions of how the Bible functions theopolitically; and introductions to key movements such as liberation theology, Catholic social teaching, and radical orthodoxy. An invaluable resource for students and scholars in theology, the Companion will al

This textbook is an introduction to the theory of Hilbert space and its applications. The notion of Hilbert space is central in functional analysis and is used in numerous branches of pure and applied mathematics. Dr Young has stressed applications of the theory, particularly to the solution of partial differential equations in mathematical physics and to the approximation of functions in complex analysis. Some basic familiarity with real analysis, linear algebra and metric spaces is assumed, but otherwise the book is self-contained. It is based on courses given at the University of Glasgow and contains numerous examples and exercises (many with solutions). Thus it will make an excellent first course in Hilbert space theory at either undergraduate or graduate level and will also be of interest to electrical engineers and physicists, particularly those involved in control theory and filter design.

This 2005 volume contains the papers presented in honor of the lifelong achievements of Thomas J. Rothenberg on the occasion of his retirement. The authors of the chapters include many of the leading econometricians of our day, and the chapters address topics of current research significance in econometric theory. The chapters cover four themes: identification and efficient estimation in econometrics, asymptotic approximations to the distributions of econometric estimators and tests, inference involving potentially nonstationary time series, such as processes that might have a unit autoregressive root, and nonparametric and semiparametric inference. Several of the chapters provide overviews and treatments of basic conceptual issues, while others advance our understanding of the properties of existing econometric procedures and/or propose others. Specific topics include identification in nonlinear models, inference with weak instruments, tests for nonstationary in time series and panel

Algebraic geometry, central to pure mathematics, has important applications in such fields as engineering, computer science, statistics and computational biology, which exploit the computational algorithms that the theory provides. Users get the full benefit, however, when they know something of the underlying theory, as well as basic procedures and facts. This book is a systematic introduction to the central concepts of algebraic geometry most useful for computation. Written for advanced undergraduate and graduate students in mathematics and researchers in application areas, it focuses on specific examples and restricts development of formalism to what is needed to address these examples. In particular, it introduces the notion of Gröbner bases early on and develops algorithms for almost everything covered. It is based on courses given over the past five years in a large interdisciplinary programme in computational algebraic geometry at Rice University, spanning mathematics, computer

This work was originally issued as a two-volume set, published in 1987 and 1988. It constitutes a definitive presentation of the system of classifying moral judgment built up by Lawrence Kolberg and his associates over a period of twenty years. Researchers in human development and education around the world, many of whom have worked with interim versions of the system - indeed, all those seriously interested in understanding the development of moral judgment - will find it a useful and accessible resource. Volume 2 includes the scoring systems for three alternate, functionally equivalent forms of Kohlberg's moral judgment interview.

For decades, social perspectives, and even academic studies of language, have considered clichés as a hackneyed, tired, lazy, unthinking and uninspiring form of communication. Authored by two established scholars in the fields of Systemic-Functional Linguistics and Discourse Studies and Pragmatics, this cutting-edge book comprehensively explores the perception and use of clichés in language from these complementary perspectives. It draws data from a variety of both written and spoken sources, to re-interrogate and re-imagine the nature, role and usage of clichés, identifying the innovative and creative ways in which the concepts are utilised in communication, interaction, and in self-presentation. Observing a rich, complex layering of usage, the authors deconstruct the many and varied ways in which clichés operate and are interdependently constructed; from the role they play in discourse in general, to their functions as argumentative strategies, as constructs of social cognition, as p

For decades, social perspectives, and even academic studies of language, have considered clichés as a hackneyed, tired, lazy, unthinking and uninspiring form of communication. Authored by two established scholars in the fields of Systemic-Functional Linguistics and Discourse Studies and Pragmatics, this cutting-edge book comprehensively explores the perception and use of clichés in language from these complementary perspectives. It draws data from a variety of both written and spoken sources, to re-interrogate and re-imagine the nature, role and usage of clichés, identifying the innovative and creative ways in which the concepts are utilised in communication, interaction, and in self-presentation. Observing a rich, complex layering of usage, the authors deconstruct the many and varied ways in which clichés operate and are interdependently constructed; from the role they play in discourse in general, to their functions as argumentative strategies, as constructs of social cognition, as p

Framework agreements have arisen in response to the well documented and high costs of public procurement procedures. The agreements have significant potential to improve procedural efficiency in public procurement, but are complex to operate. Inadequate preparation and implementation can also frustrate their potential both to tackle waste, abuse and corruption and to enhance value for money. In this enlightening book, Gian Luigi Albano and Caroline Nicholas look at the key decisions required for designing and using framework agreements, and address both legal and economic issues to give the reader a clear understanding of the planning, variables and flexibility needed for efficient implementation. This book will be of interest to policy makers, lawyers and public procurement practitioners who want to deepen their understanding of the legal and economic issues surrounding framework agreements.

With nearly 100 different autoimmune diseases reported to occur in domestic animal species, this evidence-based clinical reference is a must-have for every veterinary practice! Autoimmune Diseases in Domestic Animals, from noted veterinary author Ian R. Tizard, sheds light on both common and rare conditions, including skin diseases, diabetes mellitus, thyroiditis, and hemolytic anemia. Convenient and portable, this single-source review addresses autoimmune diseases in dogs, cats, horses, and livestock species with comprehensive coverage of treatment protocols, diagnostic procedures, and the latest pathogenesis studies. All-in-one guide covers the basic science, clinical presentation, and treatment of this set of increasingly prevalent animal diseases. Comprehensive information for each disease prepares students to communicate effectively with clients. Reviews of the most recent relevant literature provide a clearer understanding of complex autoimmune diseases. Detailed coverage facil

Sub-Riemannian manifolds are manifolds with the Heisenberg principle built in. This comprehensive text and reference begins by introducing the theory of sub-Riemannian manifolds using a variational approach in which all properties are obtained from minimum principles, a robust method that is novel in this context. The authors then present examples and applications, showing how Heisenberg manifolds (step 2 sub-Riemannian manifolds) might in the future play a role in quantum mechanics similar to the role played by the Riemannian manifolds in classical mechanics. Sub-Riemannian Geometry: General Theory and Examples is the perfect resource for graduate students and researchers in pure and applied mathematics, theoretical physics, control theory, and thermodynamics interested in the most recent developments in sub-Riemannian geometry.

How can healthcare systems be transformed by reimagining their multiple silos to favor processes and practices that are more responsive to local, horizontal initiatives? Altering Frontiers analyzes numerous experiences, using a multidisciplinary approach, paying attention to certain actors, collectives and organizational arrangements.Through this work, levers are identified that promote lasting transformation: recognizing the legitimacy of the practices of many who are often invisible; trusting those who know their intervention territory; investing in methodological support; taking advantage of tools and procedures such as instruments for strategic and managerial discussion; and developing the capacity to absorb innovative ideas and experiences that circulate within the environment.

The book provides a review of scientific research on the learning outcomes of students with limited or no proficiency in English in U.S. schools. Research on students in kindergarten to grade 12 is reviewed. The primary chapters of the book focus on these students' acquisition of oral language skills in English, their development of literacy (reading & writing) skills in English, instructional issues in teaching literacy, and achievement in academic domains (i.e., mathematics, science, and reading). The reviews and analyses of the research are relatively technical with a focus on research quality, design characteristics, and statistical analyses. The book provides a set of summary tables that give details about each study, including full references, characteristics of the students in the research, assessment tools and procedures, and results. A concluding chapter summarizes the major issues discussed and makes recommendations about particular areas that need further research.

The book provides a review of scientific research on the learning outcomes of students with limited or no proficiency in English in U.S. schools. Research on students in kindergarten to grade 12 is reviewed. The primary chapters of the book focus on these students' acquisition of oral language skills in English, their development of literacy (reading & writing) skills in English, instructional issues in teaching literacy, and achievement in academic domains (i.e., mathematics, science, and reading). The reviews and analyses of the research are relatively technical with a focus on research quality, design characteristics, and statistical analyses. The book provides a set of summary tables that give details about each study, including full references, characteristics of the students in the research, assessment tools and procedures, and results. A concluding chapter summarizes the major issues discussed and makes recommendations about particular areas that need further research.

This straightforward course based on the idea of a limit is intended for students who have acquired a working knowledge of the calculus and are ready for a more systematic treatment which also brings in other limiting processes, such as the summation of infinite series and the expansion of trigonometric functions as power series. Particular attention is given to clarity of exposition and the logical development of the subject matter. A large number of examples is included, with hints for the solution of many of them.

Modern Computer Arithmetic focuses on arbitrary-precision algorithms for efficiently performing arithmetic operations such as addition, multiplication and division, and their connections to topics such as modular arithmetic, greatest common divisors, the Fast Fourier Transform (FFT), and the computation of elementary and special functions. Brent and Zimmermann present algorithms that are ready to implement in your favourite language, while keeping a high-level description and avoiding too low-level or machine-dependent details. The book is intended for anyone interested in the design and implementation of efficient high-precision algorithms for computer arithmetic, and more generally efficient multiple-precision numerical algorithms. It may also be used in a graduate course in mathematics or computer science, for which exercises are included. These vary considerably in difficulty, from easy to small research projects, and expand on topics discussed in the text. Solutions to selected e

This book is an introductory textbook on the physical processes occurring in the Earth's radiation belts. The presentation is at the advanced undergraduate or first year graduate level, and it is appropriate for students who intend to work in some aspect of magnetospheric physics. The treatment is quantitative and provides the mathematical basis for original work in this subject. The equations describing the motion of energetic ions and electrons in the geomagnetic field are derived from basic principles, and concepts such as magnetic field representations, guiding centre motion, adiabatic invariance, and particle distribution functions are presented in a detailed and accessible manner. Relevant experimental techniques are reviewed and a summary is given of the intensity and energy spectra of the particle populations in the Earth's radiation belts. Problem sets are included as well as appendices of tables, graphs and frequently used formulas.

The aim of this book is to develop the combinatorics of Young tableaux and to show them in action in the algebra of symmetric functions, representations of the symmetric and general linear groups, and the geometry of flag varieties. The first part of the book is a self-contained presentation of the basic combinatorics of Young tableaux, including the remarkable constructions of 'bumping' and 'sliding', and several interesting correspondences. In Part II these results are used to study representations with geometry on Grassmannians and flag manifolds, including their Schubert subvarieties, and the related Schubert polynomials. Much of this material has never appeared in book form.There are numerous exercises throughout, with hints or answers provided. Researchers in representation theory and algebraic geometry as well as in combinatorics will find Young Tableaux interesting and useful; students will find the intuitive presentation easy to follow.

Originally published in 1926, this textbook was aimed at first-year undergraduates studying physics and chemistry, to help them become acquainted with the concepts and processes of differentiation and integration. Notably, a prominence is given to inequalities and more specifically to inequations, as reflected in the syllabus and general practice of the time. The book is divided into four parts: 'Number', 'Logarithms', 'Functions' and 'Differential and integral calculus'. Appendices are included as well as biographical notes on the mathematicians mentioned and an index of symbols. A self-contained and systematic introduction on mathematical analysis, this book provides an excellent overview of the essential mathematical theorems and will be of great value to scholars of the history of education.

Obtain better system performance, lower energy consumption, and avoid hand-coding arithmetic functions with this concise guide to automated optimization techniques for hardware and software design. High-level compiler optimizations and high-speed architectures for implementing FIR filters are covered, which can improve performance in communications, signal processing, computer graphics, and cryptography. Clearly explained algorithms and illustrative examples throughout make it easy to understand the techniques and write software for their implementation. Background information on the synthesis of arithmetic expressions and computer arithmetic is also included, making the book ideal for newcomers to the subject. This is an invaluable resource for researchers, professionals, and graduate students working in system level design and automation, compilers, and VLSI CAD.

Thoroughly revised and updated to reflect current and emerging practices, this book explores modern methods of disease control in field and glasshouse crops. It outlines the major crop diseases, with a particular emphasis on those features of symptomology and life cycle that are most relevant to the development of control measures. Modern diagnostic techniques are considered, focusing on developments in nucleic acid and immunological based procedures and their use in plant quarantine and certification schemes. The potential impact of these advances in molecular technology on plant breeding and disease resistance is also covered. Fungicides are a central part of disease control in the EU and, as such, a comprehensive account of their use forms an important part of the text, along with strategies to minimise the incidence of fungicide resistance in pathogen populations. Looking to the future, the book also addresses legislative, environmental and food safety concerns.

This 1992 book provides a thorough and systematic description of particle field holography. The use of holography to study very small objects in a dynamic volume is a technique of importance for scientists and engineers across a variety of disciplines for obtaining information about the size, shape and velocity of small objects such as dust particles, fuel droplets, raindrops, pollen, bubbles etc. Professor Vikram has made major contributions to the field, and here provides a coherent, comprehensive and self-contained treatment of the theory, practise and applications. The volume is written to satisfy the needs of researchers in the technique, practising engineers dealing with applications, and advanced students in science or engineering departments. All the necessary mathematical formulations, figures and photographs, experimental procedures and results, and literature citations are therefore included.

This 1992 book provides a thorough and systematic description of particle field holography. The use of holography to study very small objects in a dynamic volume is a technique of importance for scientists and engineers across a variety of disciplines for obtaining information about the size, shape and velocity of small objects such as dust particles, fuel droplets, raindrops, pollen, bubbles etc. Professor Vikram has made major contributions to the field, and here provides a coherent, comprehensive and self-contained treatment of the theory, practise and applications. The volume is written to satisfy the needs of researchers in the technique, practising engineers dealing with applications, and advanced students in science or engineering departments. All the necessary mathematical formulations, figures and photographs, experimental procedures and results, and literature citations are therefore included.

Understand the rapidly growing complexities of obstetric hematology and high-risk pregnancy management, with experts in the field. Now in its second edition, this comprehensive and essential guide focuses on providing the best support for patients and clinical staff, to prevent serious complications in pregnancy and the post-partum period for both mother and baby. Wide-ranging and detailed, the guide offers discussions on basic principles of best care, through to tackling lesser-known hematological conditions, such as cytopenias and hemoglobinopathies. Updated with color illustrations, cutting-edge research, accurate blood film reproductions, and practical case studies, the revised edition places invaluable advice into everyday context. This unique resource is essential reading for trainees and practitioners in obstetrics, anesthesia, and hematology, as well as midwives, nurses, and laboratory staff. Clarifying difficult procedures for disease prevention, the guide ensures safety when

The 'ethical commonwealth', the central social element in Kant's account of religion, provides the church, as 'the moral people of God', with a role in establishing a cosmopolitan order of peace. This role functions within an interpretive realignment of Kant's critical project that articulates its central concern as anthropological: critically disciplined reason enables humanity to enact peacemaking as its moral vocation in history. Within this context, politics and religion are not peripheral elements in the critical project. They are, instead, complementary social modalities in which humanity enacts its moral vocation to bring lasting peace among all peoples.

The first complete survey of reclaimed wood, combining useful information, rich history, and design ideasThe first handbook on reclaimed wood, combining useful information, rich history, and design ideasWood reclaimed from old houses, factories, barns, water tanks, and boardwalks has become a valuable commodity, treasured for the patina that gives witness to its history. Our ancestors built well, using locally sourced lumber that expressed the culture and natural history of their region: oak and pine in the Northeast; hickory and cypress in the South; Douglas fir and redwood in the West. Reclaimed Wood: A Field Guide is the first complete visual handbook to this popular resource, covering history, culture, salvage, sources, contemporary uses (in buildings and furniture), and practical advice.

Despite the growing scholarly interest in comparative public law, there remain relatively few works on the subject. Contemporary French Administrative Law aims to redress that imbalance, offering English-language readers an authoritative introduction to the key features of French administrative law and its institutions. The French legal system is among the most well-developed and influential in the world, and, as procedures continually adapt to European and international influences, it has never been more worthy of research, study and interrogation. This book employs a wide range of recent, illustrative cases to demonstrate how French administrative law works both in theory and in practice. Using a systematic approach and covering everything from judicial review to public contracts, this is a highly valuable text for any student or researcher with an interest in French law. The book is also available as Open Access.

This book concisely examines the use of elasticity in solving geotechnical engineering problems. In a highly illustrated and user-friendly format, it provides a thorough grounding in the linear theory of elasticity and an understanding of the applications, for upper level students in civil engineering and engineering geology. The first two chapters present a basic framework of the theory of elasticity and describe test procedures for the determination of elastic parameters for soils. Chapters 3 and 4 present the fundamental solutions of Boussinesque, Kelvin and Mindlin and use these to formulate solutions to problems of practical interest in geotechnical engineering. The book concludes with a sequence of appendices designed to provide the interested student with details of elasticity theory which are peripheral to the main text. Each chapter includes a set of questions for the student to answer.

This book concisely examines the use of elasticity in solving geotechnical engineering problems. In a highly illustrated and user-friendly format, it provides a thorough grounding in the linear theory of elasticity and an understanding of the applications, for upper level students in civil engineering and engineering geology. The first two chapters present a basic framework of the theory of elasticity and describe test procedures for the determination of elastic parameters for soils. Chapters 3 and 4 present the fundamental solutions of Boussinesque, Kelvin and Mindlin and use these to formulate solutions to problems of practical interest in geotechnical engineering. The book concludes with a sequence of appendices designed to provide the interested student with details of elasticity theory which are peripheral to the main text. Each chapter includes a set of questions for the student to answer.

In this globetrotting tour of seventeen houses, discover how bamboo, one of the most sustainable building materials on the planet, can be used in ingenious ways in residential design.Bamboo is a perennial grass that grows rapidly and rivals steel, concrete, and wood in strength. Bamboo Contemporary shows the many ways this incredible material can be used to build sustainably. Featuring locales from China to the Czech Republic and the United States, the survey includes homes built entirely from bamboo as well as building projects and renovations that use bamboo as the primary component. Fascinating descriptions, documentary photography, and architectural drawings will appeal to aspirational lifestyle readers interested in sustainability and natural materials as well as design professionals.

This book examines the vital role of market towns in the medieval economy. It focuses on Exeter, and on how it served as an important link in a marketing chain that connected local, regional, and overseas trade. Although small by most standards (the population stood at around 3,100 in 1377), Exeter was the largest town in south-western England and had long played a central role in the marketing hierarchy of the region. Its functions can be illustrated through prosopographical analysis, a methodology which creates 'collective biographies' of specific groups of traders, thereby revealing the identity - status, occupation, residence - of buyers and sellers, the goods they exchanged, where they traded, and how they marketed their goods. Such an approach also helps to characterise the town's regional networks of trade and hinterland.

This book examines the vital role of market towns in the medieval economy. It focuses on Exeter, and on how it served as an important link in a marketing chain that connected local, regional, and overseas trade. Although small by most standards (the population stood at around 3,100 in 1377), Exeter was the largest town in south-western England and had long played a central role in the marketing hierarchy of the region. Its functions can be illustrated through prosopographical analysis, a methodology which creates 'collective biographies' of specific groups of traders, thereby revealing the identity - status, occupation, residence - of buyers and sellers, the goods they exchanged, where they traded, and how they marketed their goods. Such an approach also helps to characterise the town's regional networks of trade and hinterland.

The Premium edition of our popular annual study guide that provides all the info students need to succeed on the AP Calculus AB Exam―with 7 full-length practice tests for maximum scoring success.AP Calculus AB Premium Prep, 2023 is dedicated to the calculus topics students need to master to succeed on the AB test, including functions, graphs, limits, derivatives, and integrals. The exam covers the material taught in a full-year course, and this edition reflects all the topics covered by the exam, the curriculum structure, and the exam setup and question types.

Service encounters are ubiquitous in social interaction. We buy food and everyday items in supermarkets, convenience stores, or markets; we purchase merchandise in department stores; or we request information at a visitor information center. This book offers a comprehensive account of service encounters in commercial and non-commercial settings. Grounded in naturally occurring face-to-face interactions and drawing on a pragmatic-discursive approach, J. César Félix-Brasdefer sets out a framework for the analysis of transactional and relational talk in various contexts in the United States and Mexico. This book investigates cross-cultural and intra-lingual pragmatic variation during the negotiation of service. The author provides a broad review of research on service encounters to date, and analyzes characteristics of sales transactions, such as participants' roles, pragmatic and discourse functions of relational talk and address forms, the realization of politeness, and changes in align

Service encounters are ubiquitous in social interaction. We buy food and everyday items in supermarkets, convenience stores, or markets; we purchase merchandise in department stores; or we request information at a visitor information center. This book offers a comprehensive account of service encounters in commercial and non-commercial settings. Grounded in naturally occurring face-to-face interactions and drawing on a pragmatic-discursive approach, J. César Félix-Brasdefer sets out a framework for the analysis of transactional and relational talk in various contexts in the United States and Mexico. This book investigates cross-cultural and intra-lingual pragmatic variation during the negotiation of service. The author provides a broad review of research on service encounters to date, and analyzes characteristics of sales transactions, such as participants' roles, pragmatic and discourse functions of relational talk and address forms, the realization of politeness, and changes in align

Family and the Law in Eighteenth-Century Fiction offers challenging interpretations of the public and private faces of individualism in the eighteenth-century English novel. John P. Zomchick begins by surveying the social, historical and ideological functions of law and the family in England's developing market economy. He goes on to examine in detail their part in the fortunes and misfortunes of the protagonists in Defoe's Roxana, Richardson's Clarissa, Smollett's Roderick Random, Goldsmith's The Vicar of Wakefield and Godwin's Caleb Williams. Zomchick reveals in these novels an attempt to produce a 'juridical subject': a representation of the individual identified with the principles and aims of the law, and motivated by an inherent need for affection and community fulfilled by the family. Their ambivalence towards that formulation indicates a nostalgia for less competitive social relations, and an emergent liberal critique of the law's operation in the service of society's elites.

Given the controversies and difficulties which preceded the coming into force of the Lisbon Treaty, it is easy to forget that the Treaty is a complex legal document in need of detailed analysis for its impact to be fully understood. Jean-Claude Piris, the Director General of the Legal Service of the Council of the European Union, provides such an analysis, looking at the historical and political contexts of the Treaty, its impact on the democratic framework of the EU and its provisions in relation to substantive law. Impartial legal analysis of the EU's functions, its powers and the treaties which govern it make this the seminal text on the most significant recent development in EU law.