SQL Server Common statements

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