Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about how to batch update sentences in SqlServer. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

Examples of sqlserver as grammar

1. Use the table name to alias

There are two tables: "Persons" and "Product_Orders". Assign them aliases "p" and "po", respectively. List all orders for "John Adams".

SELECT po.OrderID, p.LastName, p.FirstNameFROM Persons AS p, Product_Orders AS poWHERE p.LastNameplates Adams' AND p.FirstNameplates John'

2. Use column name aliases

Query the LastName column in the Persons table (define the alias' last name 'for it) and the FirstName column (define the alias' first name 'for it), and output all the result values.

SELECT LastName AS last name, FirstName AS first name FROM Persons

3. Use both table and column names

Define the alias' alias' for the city table and use that table alias to query all information about the ID column in the table (alias B is defined for the ID column).

SELECT A.ID AS BFROM city AS A; above is how to batch update statements in SqlServer shared by Xiaobian. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.