Location:
Search - t-sql a
Search list
Description: This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)¡ ª one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on language features and how they are interpreted and processed by the SQL Server execution engine. You¡ ¯ ll get in-depth coverage of the sophisticated uses of T-SQL, including triggers, user-defined functions, exception handling, and more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server 2005 in detail. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL.-This thorough, hands-on reference for database developers an d administrators delivers expert guidance on s ophisticated uses of Transact-SQL (T-SQL)
Platform: |
Size: 2757371 |
Author: li ming |
Hits:
Description: 一个餐饮进销存系统
数据库要求：SQL Server 2000
系统要求：Windows操作系统；
安装程序以前，首先创建相关的数据库。创建方法：用SQL Server2000
的查询分析器打开SQL目录下的myrestaurant.sql，并执行。-a Food Invoicing System database requirements : SQL Server 2000 system requirements : Windows; before the installation procedure, the first to create the database. Create ways : Using SQL Server 2000 to open inquiries analyzer SQL directory of myrestauran t.sql and implementation.
Platform: |
Size: 152576 |
Author: |
Hits:
Description: This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)¡ ª one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on language features and how they are interpreted and processed by the SQL Server execution engine. You¡ ¯ ll get in-depth coverage of the sophisticated uses of T-SQL, including triggers, user-defined functions, exception handling, and more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server 2005 in detail. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL.-This thorough, hands-on reference for database developers an d administrators delivers expert guidance on s ophisticated uses of Transact-SQL (T-SQL)
Platform: |
Size: 2756608 |
Author: li ming |
Hits:
Description: SQL Server 数据库开发经典实例精解
书主要介绍如何使用SQL Server 2000进行数据库管理系统的开发。全书共分3篇：基础篇、应用篇和高级篇，各篇中的实例涉及SQL Server 2000数据库管理系统管理和开发领域中的应用。基础篇介绍了关系数据库的基础知识，SQL Server 2000的基本特点、版本、安装和T-SQL基础；应用篇包括4个小型实例：创建学分制选课数据库、创建学分制选课数据库表、创建选课记录查询和创建XML查询；高级篇包括3个比较大型的综合实例：创建学生信息管理窗体、学分制选课管理系统和图书销售系统。各篇实例的实用性极强，涵盖了SQL Server 2000数据库管理系统管理和开发的大部分操作知识点，主要包括数据库管理、数据表管理、查询和视图、XML查询和ADO数据库访问组件等。.
本书定位于已有一定基础的SQL Server 2000初中级用户、数据库管理系统开发相关人员以及电脑爱好者学习使用，还可作为社会相关办学、大中专院校的辅助教材。..
为了方便读者学习和操作，书中实例所涉及的源代码都收录在本书的配套光盘中，供读者在学习过程中调用。 -SQL Server database development precision classic example of the major solutions on how to use SQL Serv er 2000 database management system development. The book is divided into three : The Basics, application and senior chapter, a chapter the chapter of the case, involving the SQL Server 2000 database management system for the management and development of the field of application. Basics introduces the basic knowledge database, SQL Server 2000's basic features, version, Installation and T-SQL basis; Application of articles, including four small example : Create Course Credit System database, Elective credit system to create database tables, create Course record inquiry and the creation of XML query; High articles include three large-scale and comprehensive example : Create Student Inf
Platform: |
Size: 809984 |
Author: wu |
Hits:
Description: Delphi写的一个格式化T-SQL的程序，源代码简单易读，格式化T-SQL非常快速，并且有很多选项轻松的设置格式-Delphi to write a formatted T-SQL procedures, the source code easier to read, formatted T-SQL very fast, and there are many easy options to format
Platform: |
Size: 237568 |
Author: tanke |
Hits:
Description: delphi+SQL编写的销售系统，功能不错，可以提供不错的参考，本人学生 自己写的小程序，-delphi+ SQL prepared marketing systems, function well, can provide a good reference, I have students write their own small procedures,
Platform: |
Size: 5025792 |
Author: zhoujiajian |
Hits:
Description: SQL Server 2005微软官方权威参考手册.
是Inside Microsoft SQL Server 2005系列书中的第一本，SQL Server类的顶尖之作
全球公认SQL Server 2005经典著作，囊括大量鲜为人知的技术内幕，大师智慧、专家经验尽览无余。..
本系列图书中文版得到了微软总部SQL Server组专家的高度重视，同时也得到了微软中国上海SQL Server全球技术支持中心的高度关注。...
-SQL Server 2005 Microsoft official authoritative reference manual. Is Inside Microsoft SQL Server 2005 series of the first book, SQL Server category of the top globally recognized for SQL Server 2005 classic, includes a large number of little-known technical insider, master of wisdom, expertise无余nodes. .. In this series of books has been the Chinese version of Microsoft SQL Server team of experts from the headquarters of high priority, but also by the Microsoft SQL Server Shanghai, China, the global technical support center attention. ...
Platform: |
Size: 2710528 |
Author: 李凤杰 |
Hits:
Description: 为学习T-Sql的初学者准备的一个自动建立数据库、表、练习数据的Sql脚本文件。-To study the T-Sql a beginner ready to automatically create the database, tables, practice data Sql script file.
Platform: |
Size: 1024 |
Author: chenxiansheng |
Hits:
Description: Sams Teach Yourself sql server is a good one for self study
Platform: |
Size: 906240 |
Author: ayhamz |
Hits:
Description: Right from the start, this book will expand your basic knowledge, and you will soon find yourself
moving from a beginner toward a competent and professional developer. This book aims to cater to
a wide range of developers, from those who prefer to use a graphical interface for as much work as
possible, to those who want to become more adept at using SQL Server 2008’s programming language,
Transact SQL (T-SQL). Where practical, this book demonstrates, explains, and expands upon each
method of using SQL Server 2008 so that you can evaluate which works best in your situation.
Platform: |
Size: 15124480 |
Author: Di_Ablo |
Hits:
Description: The T-SQL Programming book is generously laced with practical code samples you can easily use in your own work. The authors think beyond the correctness of the samples and take security, performance, and potential blocking into consideration as well. Therefore, the book contains numerous examples in which the query plans are examined and compared with alternative plans. For instance, in Chapter 9, you will find information about how to use dynamic management views (DMVs) to troubleshoot blocking scenarios. DMVs were newly introduced in SQL Server 2005 to provide information about the server state that can be used to monitor the health of a server instance, diagnose problems, and tune performance.-The T-SQL Programming book is generously laced with practical code samples you can easily use in your own work. The authors think beyond the correctness of the samples and take security, performance, and potential blocking into consideration as well. Therefore, the book contains numerous examples in which the query plans are examined and compared with alternative plans. For instance, in Chapter 9, you will find information about how to use dynamic management views (DMVs) to troubleshoot blocking scenarios. DMVs were newly introduced in SQL Server 2005 to provide information about the server state that can be used to monitor the health of a server instance, diagnose problems, and tune performance.
Platform: |
Size: 2756608 |
Author: asd2010 |
Hits:
Description: T-SQL编程结构介绍。包括注释结构、变量声明、判断和循环、游标、事务、、备份等基本概念。是入门的好书籍-Introduced T-SQL programming structure. Including annotations structure, variable declarations, judgments, and circulation, cursors, transactions, backup and other basic concepts. Is a good book entry
Platform: |
Size: 355328 |
Author: 苏应数 |
Hits:
Description: 一、实验目的
1）理解视图的概念。
2）掌握创建视图的方法。
3）掌握更改视图的方法。
4）掌握用视图管理数据的方法。
二、实验内容
3、用T-SQL语言创建、管理视图 （以下题目需提交）
（1）创建视图
1）创建一个名为stuview2的水平视图，从数据库XSGL的student表中查询出性别为“男”的所有学生的资料。并在创建视图时使用with check option。（注：该子句用于强制视图上执行的所有修改语句必须符合由Select语句where中的条件。）
T-SQL语句为：
Create view stuview2
As
Select *
From student
Where sex= 男
-1, experimental purposes 1) understand the concept of view. 2) to master the method to create the view. 3) control to change the view method. 4) The master with the view of management data. Second, the contents of three experiments, using T-SQL language to create, manage view (the following topics should be submitted) (1) create a view of a) Create a file called stuview2 level view of the student table from the database query XSGL the gender as " male " All the students information. Used in the creation of the view with check option. (Note: This clause is used to force all the modifications performed on the view must be consistent with statements by the Select statement where the condition.)
Platform: |
Size: 200704 |
Author: kice |
Hits:
Description: T-SQL个人语法帮助 T-SQL个人语法帮助 T-SQL个人语法帮助 T-SQL个人语法帮助-T-SQL syntax to help individuals personal T-SQL syntax to help T-SQL syntax to help individuals personal T-SQL syntax to help T-SQL syntax to help individuals T-SQL syntax to help individuals
Platform: |
Size: 10240 |
Author: 千纸鹤 |
Hits:
Description:
数据库课程设计指导书
一、 设计题目：图书馆管理系统
二、 设计目的：
1. 进一步学习和掌握数据库原理的基础知识和理论。
2. 学习SQL Server数据库管理系统的基本功能和建立数据库各种对象的方法。
3. 熟练掌握和使用SQL语言操纵数据库，使用T-SQL语言编程。
4. 理解和掌握利用数据库所学的理论知识来设计数据库的基本方法和步骤。
5. 通过上机操作和调试程序，提高学生理论联系实际和动手操作能力。
三、 设计内容和步骤：
1. 需求分析：根据图书馆信息管理系统的用户需求，确定图书馆管理系统数据需求和功能需求。
数据需求: 读者信息、图书信息、出版社信息、借阅信息等。
功能需求: 数据的更新功能（如读者数据插入，删除和修改等）
借书和还书功能
数据的查询功能（如根据读者号查询其所借的全部书籍等）
统计功能（如根据读者号查询其所借图书数量的函数,统计所有逾期未还的书及其罚款金额等）
……
2. 概念模型设计：根据需求分析的结果，确定组成本系统的实体、属性和实体间的联系。设计系统E-R 图。
系统的E-R 图： -Database curriculum design guide book
1, Design Title: Library Management System
2, designed to:
1. Further study and master the basics of database principles and theories.
2. To learn SQL Server database management system s basic functions and the establishment of a database of various objects methods.
3. Familiar with and use the SQL language to manipulate database using T-SQL language programming.
4. Understand and master the use of databases to learn the theoretical knowledge to design a database of basic methods and procedures.
5. Through computer operation and debugging procedures, to enhance students integrate theory with practice and hands-on operational capability.
Third, design the content and steps:
1. Requirements Analysis: According to the library information management system user needs to determine the library management system data requirements and functional requirements.
Data needs: the reader information, book information, publishing information
Platform: |
Size: 11264 |
Author: 赖俊科 |
Hits:
Description: 很好的一个技术文档，对于学习数据库很有帮助-A good technical documentation for the study database helpful
Platform: |
Size: 2710528 |
Author: 胡鹏 |
Hits:
Description: This book is intended for SQL Server developers and DBAs who want to get the most out of SQL
Server 2008 Integrated Full-Text Search (iFTS). To get the most out of this book, you should
have a working knowledge of T-SQL, as most of the sample code in the book is written in SQL
Server 2008 T-SQL. Sample code is also provided in C# and C++, where appropriate. Although
knowledge of these programming languages is not required, basic knowledge of procedural
programming will help in understanding the code samples.
Platform: |
Size: 3186688 |
Author: arash |
Hits:
Description: sql2000的T-SQL语言入门编程书籍，是老师上课时推荐使用的辅导书-a T-SQL programm book ，it is a basic book
Platform: |
Size: 340992 |
Author: 吉喆 |
Hits:
Description: T-SQL提供标准SQL的DDL和DML功能，加上延伸的函数、系统预存程序以及程式设计结构(例如 IF 和 WHILE)让程式设计更有弹性。本书主要侧重于数据报表，书中还包括了新的语句，其中将用于创建和管理对象。本书介绍的一些概念将帮助你成为一个熟练的T-SQL程序员。本书为英文版。-T-SQL provides standard SQL DDL and DML functions, plus extended functions, system stored procedures, and programming structure (such as IF and WHILE) program to design more flexible. This book focuses on the data report, the book also includes a new statement, which will be used to create and manage objects. Some of the concepts introduced in this book will help you become a skilled T-SQL programmers. This book is the English version.
Platform: |
Size: 14130176 |
Author: 张楚 |
Hits:
Description: 一个嵌套代码块中的语句使用四个空格的缩进。（上述代码中的多行 SELECT 语句是一个 SQL 语句。）在同一语句中开始新行时，使 SQL 关键字右对齐。将代码编辑器配置为使用空格，而不是使用制表符[每个制表符对应为4个空格，请在SQL编辑器中进行设置。]。这样，不管使用何种程序查看代码，格式都是一致的。(A statement in a nested block of code that uses four spaces for indentation. The multiline SELECT statement in the above code is a SQL statement When you start a new row in the same statement, make the SQL keyword right justified. Configure the code editor to use spaces instead of tabs. [each tab corresponds to 4 spaces. Set it in the SQL editor. ]. Thus, the format is consistent regardless of which program is used to view the code.)
Platform: |
Size: 379904 |
Author: 哦嚯嘢哒哨
|
Hits: