Operations between two tables in the T-SQL database, t-SQL database operations

Source: Internet
Author: User

Operations between two tables in the T-SQL database, t-SQL database operations

-- Modify data in a table based on another table
Update Admin_FCOutDt set oLastId = T. contractID from (select crm_contract.contractTopic, crm_contract.contractID from Admin_FCOutDtleft join crm_contract on rows = crm_contract.contractTopic) Twhere rows = T. contractTopic -- insert into Admin_FCOutDt (protype, number) select 'test', num from crm_contract -- delete data from Admin_FCOutDt where LastId in (se Lect id from Admin_FCOut where prod like '% EF %') -- merge two tables for query (the query between two tables only lists this one. There will be separate chapters) select fnumber, fname from Admin_FCOutDt where state = 1 union allselect nub as fnumber, fname from crm_comtract

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.