通过 SQL，您如何向 "Persons" 表中的 "LastName" 列插入 "Wilson" ？
A: INSERT INTO Persons (LastName) VALUES ('Wilson')
B: INSERT ('Wilson') INTO Persons (LastName)
C: INSERT INTO Persons ('Wilson') INTO LastName
A: INSERT INTO Persons (LastName) VALUES ('Wilson')
B: INSERT ('Wilson') INTO Persons (LastName)
C: INSERT INTO Persons ('Wilson') INTO LastName
举一反三
- 通过 SQL，您如何向 "Persons" 表中的 "LastName" 列插入 "Wilson" ？ A: INSERT INTO Persons (LastName) VALUES ('Wilson') B: INSERT ('Wilson') INTO Persons (LastName) C: INSERT INTO Persons ('Wilson') INTO LastName
- 您如何把 "Persons" 表中 "LastName" 列的 "Gates" 改为 "Wilson" ？ A: MODIFY Persons SET LastName='Wilson' WHERE LastName='Gates' B: UPDATE Persons SET LastName='Wilson' WHERE LastName='Gates' C: UPDATE Persons SET LastName='Wilson' INTO LastName='Gates' D: MODIFY Persons SET LastName='Wilson' INTO LastName='Gates'
- 通过 SQL，向 "Actor" 表中的 "LastName" 列插入 "Wilson"表述正确的是（）。 A: INSERT INTO Actor (LastName) VALUES ('Wilson') B: INSERT INTO Actor ('Wilson') INTO LastName C: INSERT INTO Actor ('Wilson') INTO (LastName) D: INSERT ('Wilson') INTO Actor (LastName)
- 通过 SQL，您如何向 "Persons" 表中的 "LastName" 列插入 "Wilson" ？
- 通过 SQL，您如何按字母顺序选取 Persons 表中 LastName 介于 Adams 和 Carter 之间（含其本身）的所有记录？ A: SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter' B: SELECT * FROM Persons WHERE LastName>'Adams' AND LastName C: SELECT LastName>'Adams' AND LastName