The SQL INSERT INTO SELECT syntax
The general syntax is:
- INSERT INTO table–name (column–names)
- SELECT column–names
- FROM table–name
- WHERE condition
SQL INSERT SELECT INTO
Problem: Copy all Canadian suppliers into the Customer table
- INSERT INTO Customer (FirstName, LastName, City, Country, Phone)
- SELECT LEFT(ContactName, CHARINDEX(‘ ‘,ContactName) – 1) AS FirstName,
- SUBSTRING(ContactName, CHARINDEX(‘ ‘,ContactName) + 1, 100) AS LastName,
- City, Country, Phone
- FROM Supplier
- WHERE Country = ‘Canada’
LEFT, CHARINDEX, and SUBSTRING are built-in functions.
Results: 2 rows affected.
These are the two new Customer records
FirstName | LastName | City | Country | Phone |
---|---|---|---|---|
Jean-Guy | Lauzon | Montréal | Canada | (514) 555-9022 |
Chantal | Goulet | Ste-Hyacinthe | Canada | (514) 555-2955 |
핑백: mơ thấy con mèo đánh con gì
핑백: Pinball Machines for Sale
핑백: Buy Weed Online
핑백: S&W Guns for Sale
win money fast
핑백: sex dolls shop
핑백: Digital Transformation Services
핑백: ngu mo thay mau
핑백: Alex Webcams
핑백: rock island vr80
핑백: pubg cheat
핑백: mơ thấy nấu ăn
핑백: reddit best cbd oil
핑백: mơ bị sét đánh
핑백: mơ thấy em trai
핑백: white leaf
핑백: mơ thấy bếp lửa cháy
핑백: megaupload onion address
핑백: casino online
핑백: 커즐
핑백: Valentina
핑백: Advanced Plumbing Brisbane
핑백: raiders cornhole boards
핑백: buy oxycontin online,
핑백: mơ bắt cá trê
핑백: những cách khiến chàng yêu mình hơn
핑백: this post
핑백: sbobet online indonesia
핑백: Regression testing meaning