没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
This book expresses the author’s views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.
资源推荐
资源详情
资源评论
SQL Server 2012 Tutorials:
Writing Transact-SQL Statements
SQL Server 2012 Books Online
Summary: This tutorial is intended for users who are new to writing SQL statements. It
will help new users get started by reviewing some basic statements for creating tables
and inserting data. This tutorial uses Transact-SQL, the Microsoft implementation of the
SQL standard. This tutorial is intended as a brief introduction to the Transact-SQL
language and not as a replacement for a Transact-SQL class. The statements in this
tutorial are intentionally simple, and are not meant to represent the complexity found in
a typical production database.
Category: Quick Step-by-Step
Applies to: SQL Server 2012
Source: SQL Server Books Online (link to source content)
E-book publication date: June 2012
Copyright © 2012 by Microsoft Corporation
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means
without the written permission of the publisher.
Microsoft and the trademarks listed at
http://www.microsoft.com/about/legal/en/us/IntellectualProperty/Trademarks/EN-US.aspx are trademarks of the
Microsoft group of companies. All other marks are property of their respective owners.
The example companies, organizations, products, domain names, email addresses, logos, people, places, and events
depicted herein are fictitious. No association with any real company, organization, product, domain name, email address,
logo, person, place, or event is intended or should be inferred.
This book expresses the author’s views and opinions. The information contained in this book is provided without any
express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will
be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.
Contents
Tutorial: Writing Transact-SQL Statements ........................................................................................................... 4
Lesson 1: Creating Database Objects ...................................................................................................................... 5
Creating a Database (Tutorial)................................................................................................................................ 6
Creating a Table (Tutorial) ....................................................................................................................................... 7
Inserting and Updating Data in a Table (Tutorial) .......................................................................................... 8
Reading the Data in a Table (Tutorial) ............................................................................................................. 10
Summary: Creating Database Objects .............................................................................................................. 12
Lesson 2: Configuring Permissions on Database Objects ............................................................................. 12
Creating a Login ....................................................................................................................................................... 13
Granting Access to a Database ........................................................................................................................... 14
Creating Views and Stored Procedures ........................................................................................................... 15
Granting Access to a Database Object............................................................................................................. 16
Summary: Configuring Permissions on Database Objects ....................................................................... 17
Lesson 3: Deleting Database Objects ................................................................................................................... 18
Deleting Database Objects ................................................................................................................................... 18
剩余20页未读,继续阅读
资源评论
打工脱贫
- 粉丝: 0
- 资源: 12
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- (179941432)基于MATLAB车牌识别系统【GUI含界面】.zip
- (179941434)基于MATLAB车牌识别系统【含界面GUI】.zip
- (178021462)基于Javaweb+ssm的医院在线挂号系统的设计与实现.zip
- (178047214)基于springboot图书管理系统.zip
- 张郅奇 的Python学习过程
- (23775420)欧姆龙PLC CP1H-E CP1L-E CJ2M CP1E 以太网通讯.zip
- (174590622)计算机课程设计-IP数据包解析
- (175550824)泛海三江全系调试软件PCSet-All2.0.3 1
- (172742832)实验1 - LC并联谐振回路仿真实验报告1
- 网络搭建练习题.pkt
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功