SELECT * Into A--automatically generate table A, and table A's structure data is the same as table B
From B
INSERT into A--a to be created in advance
SELECT * FROM B
Insert into A (field 1, Field 2,...)
Values
(value 1, value 2,...)
INSERT INTO A
Values
(value 1, value 2,...)
Insert into A (field 1, Field 2,...)
Select field A, field B,... from B
Correct update:
Update Ut_syhh_ Conversion Rate Adjustment _ Total Account
Set customer number = B. Customer group number
From Ut_syhh_ conversion rate Adjustment _ Total account A, Ut_syhh_cs_ customer basic information Management B
where a. Customer number = B. Customer number
and B. Customer level = ' Sub Account '
Error Update:
Update Ut_syhh_ Conversion Rate Adjustment _ Total Account
Set A. Customer number = B. Customer group number
From Ut_syhh_ conversion rate Adjustment _ Total account A, Ut_syhh_cs_ customer basic information Management B
where a. Customer number = B. Customer number
and B. Customer level = ' Sub Account '
Error: Msg 4104, Level 16, State 1, line 1th
Cannot bind multiple-part identifiers "a. Customer number".
Cause of error:???
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
SQL Server Common statements