1. identifiers:(1) Definition: Just like everyone has a name, in SQL Server, each object also has a name that is used as the identity, which is the identifier. For example, database names, data table names, field names, and so on, these names are
Data Control Language DCL)
Data Control Language (DCL) is a statement used to set or change database user or role permissions. These statements include GRANT, DENY, REVOKE, and other statements. By default, only members of sysadmin, dbcreator,
4.5.1 annotation character (Annotation)
Two types of annotation characters can be used in Transact-SQL.
The ANSI standard annotation character "--" is used for single-line annotations;
The same as the C language of the program annotation symbol,
Operators, which can be used to perform arithmetic operations, concatenate strings, assign values, and compare fields, constants, and variables. In SQL Server 2012, the operators consist mainly of the following 6 major classes: arithmetic operators,
I. T-SQL overviewThe programming language that SQL Server uses to manipulate the database is Transaction-sql, or T-SQL. T-SQL differs from PL/SQL, and there is no fixed program structure.T-SQL consists of the following 4 sections:DDL: Define and
Directory
1. Programming with the Transact-SQL language
1.1. Data Definition Language DDL
1.2. Data manipulation language DML
1.3. Data Control Language DCL
1.4.transact-sql Language Basics
2.
After a period of study, I have some knowledge about databases. databases are basically composed of tables, relationships, and operations.
After a period of study, I have some knowledge about databases. databases are basically composed of tables,
Figure 1 wins the 10 Statement: SQL Server database Summary
A rough summaryAfter a period of study, I also had some knowledge about databases.Databases are basically composed of tables, relationships, and operations. For Beginners, the first thing
Mu class net
Home
Actual combat
Path
Ape asked
Notes
PythonNotebooks \ SQL Server 2012 database notes SQL Server 2012 database notes2016-10-25 16:29:33 123 views 0 Reviews Chapter One
A picture of "ten" words: SQL Server Database Summary
A rough summary.
After a period of study, also has some knowledge of the database.
The database is basically made up of tables, relationships, and operations; for beginners to learn first:
1.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.