Learn notes SQL Server database bulk query and delete content execution statements

Source: Internet
Author: User
Tags net domain

Recently has been studying the blog, in fact, is now a popular self-media, it is interesting that the netizens have written their own blog, the establishment of a small station, and now went to the platform for others to work free, but also enjoy themselves, do not know what the situation.
Blog information:
Topics: Learning topics related to reading notes.
Web site: Use a. NET domain name as the URL.
Content: Writing and contributing, such as: Camel Xiangzi good word good words
This system uses SQL Server database, because Microsoft's database is quite good, more handy, so continue, but I am a database small white, also do not program, can only slowly learn.
Query statement:
SELECT * FROM Dbo.blog.category where cate_id=5
This is a query statement, mainly used to query the database from the station how many columns, and display the relevant information column.
Delete * from Dbo.blog.category where cate_id=5
This is a DELETE statement, mainly used to delete columns from the database, of course, this is for testing, not easy to do.

The syntax above:
Query or delete a select Delete
The asterisk denotes all content, everything you query, or all content you delete, is a wildcard character.
from which table to query, the scope of the query
where represents a conditional vocabulary, followed by a query condition.
The above is the content of today's study, as a small white, from the beginning to learn is very important, I believe we will think so!

Learn notes SQL Server database bulk query and delete content execution statements

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.