📊 SQL Server
Q. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
  • (A) UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
  • (B) MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
  • (C) MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
  • (D) UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
💬 Discuss
✅ Correct Answer: (D) UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

You must be Logged in to update hint/solution

💬 Discussion


📊 Question Analytics

👁️
232
Total Visits
📽️
4 y ago
Published
🎖️
Ram Sharma
Publisher
📈
93%
Success Rate