none
change data in column

    Question

  • hi i have column name Username, Password, EmailID

    and i have data in them i want to change some ones email how can i do that plz help

    Wednesday, February 23, 2011 9:34 AM

Answers

  • Hi,

     Using  update (T-SQL) you could do changes to the existing data in one or more columns in a table or view.

    example:

    update table 
    set emailid = 'new emailid'   where  username ='Desim' 

     

    for more info on update check below URL.
    http://msdn.microsoft.com/en-us/library/ms177523.aspx 

    Regards,

     

     


    Ramakrishna
    • Marked as answer by DesipmDB Wednesday, February 23, 2011 10:15 AM
    Wednesday, February 23, 2011 9:51 AM