SQL SERVER Basics and syntax summary, starting from the beginning, bit by bit (i)

What is SQL?

• SQL refers to Structured Query Language
• SQL gives us the ability to access a database
• SQL is an ANSI standard computer language

In the use of SQL, more or less have a lot of knowledge points, here to summarize the basic syntax of SQL and some basic points of knowledge

Objective

Let's start with some humble opinion about the database and the server!

Project according to the type can be divided into C/s and b/s, the former is the client/server way, the latter is the way of Web browser/server, either way is by the front-end client sends the request packet to the server application server to process the database and return processing results, Databases in the background are divided by type: SQL Serverl, Oracle, My sql, and so on, the database language syntax can be said to be similar, mastered one, then to learn another will be relatively easy, this and programming language common point is the same. Mastering the learning of SQL is also a very necessary thing.

SQL Server as a very powerful database management software, the function is very cumbersome, and certainly enough to meet the needs of the project, here we mainly explain the database table, stored procedures and syntax, indexes, custom data structures, linked servers, import and export of server tables, database backup and other knowledge points , where the text of the stored procedure and syntax explains the syntax to be used in writing the stored procedure.

SQL SERVER starts from the beginning.

As a first contact with the database and SQL is still a bit confusing, the database as a data management software tool, using its structured approach to the orderly management of data. Install the SQL Server server on your own PC machine or server in your computer room, and then use either PC or server to install Microsoft SQL Server Management Studio to access the database.

a database can be divided into tables, views, synonyms, programmability, storage, security, where we are in the project, in the program is most commonly used in the table and programmability, programmability for our interaction with the front-end code to provide the possibility, through the stored procedure to ensure that B /C-side interaction with the server side. In a later chapter, we will explain each function of the database and the SQL code writing syntax.

What can SQL do?

• sql execute query for database
• sql can retrieve data from the database
• sql can insert new records in the database
• sql can delete records from the database
• sql can create a new database
• sql you can create a stored procedure in the database
• sql create a view in the database

Now that you have a preliminary understanding of SQL, the next chapter will explain the creation of tables in SQL and related fields.

Small summary: SQL, database, b/S, C/s

(Personal Summary Reprint please specify the source)

SQL SERVER Basics and syntax summary, starting from the beginning, bit by bit (i)