没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
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币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- Everything 快速搜索文件夹软件安装包直接下载就能用
- 创维8A16机芯 K1系列 主程序软件 电视刷机 固件升级包 V015.003.190
- Oracle 11G DataGuard在Linux下的搭建与管理
- 29602960wen
- Phison(群联) PS2251-70 量产工具
- java项目,课程设计-#-ssm-mysql-数据结构课堂考勤管理系统.zip
- 汽车起动机市场:2023年我国起动机的市场规模已高达480亿元人民币
- java项目,课程设计-#-ssm-mysql-商品信息分类管理系统.zip
- DataGuard容灾配置过程-for-Oracle11gR2
- HPSocket.Net库文件以及使用说明
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功