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

This article shares with you the content of an example analysis of batch update statements in SqlServer. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Now I have two tables, one is Shop Person, the other is Shop user.

S_PERSON

S_USER

I now want to batch modify the ACCOUNT in the S _ user table to the ACCOUNT of S_PERSON

We can find that there is a field associated with the S_PERSON table in the Suser table, and that is PERSON_ID, which is also the condition for us to update.

After finding this relationship, it will not be difficult for us to write sql.

Update S_USER set account=p.account from S_PERSON p where p.id=S_USER.person_id

The result is:

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;, thank you for your reading! This is the end of this article on "sample Analysis of batch update sentences in SqlServer". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

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.