C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !



Posted By: Arunkumar       Member Level: Silver       Posted Date: 22 Apr 2008       Category: SQL Server

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

Select Answer:

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'




      
Your Test Score: 0 / 0



Next Question: Which SQL keyword is used to sort the result-set?
Previous Question: With SQL, how can you return the number of records in the "Persons" table?
Related Questions:
  • What Does SQL Stand For?


  • Which of the following denote Transaction Control commands in SQL


  • Function to find the underperformer in MDX


  • SELECT (TO_CHAR(NVL(SQRT(59483), “INVALID”)) FROM DUAL is a valid SQL statement.


  • One hasn't taken any backup, can we restore the deleted data?


    		•

    Categories

    ASP.NET C# VB.NET 
    .NET Framework SQL Server Other 

    Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program

    Want to prepare for an interview? Try our aptitude tests and standard interview questions first.

    dotNet Slackers   BizTalk Adaptors    Web Design

    Contact Us    Privacy Policy    Terms Of Use