sql server

Posted on 2009-12-28
Last Modified: 2012-05-08
change name1 to name2 in order 704

select * from orders where orderid ='704' set name = 'newname'

is there a tutorial that shows simple sql commands
Question by:rgb192
    LVL 75

    Accepted Solution

    you need to do an update operation if you need the change to be persistant

    update orders
    set name = 'newname'
    where orderid ='704'
    LVL 75

    Assisted Solution

    by:Aneesh Retnakaran
    LVL 26

    Assisted Solution

    update O
    set name = 'newname'
    from orders O
    where orderid ='704'
    LVL 3

    Assisted Solution

    by:KinjalKumar Patel
    There are many resources posted on the web related to SQL.

    Some of them are :

    If you go on web you will many of them. Just start with this ones and let me know if you need anything else or you want some startup training on it will surely give you a brief intro on it.

    LVL 5

    Assisted Solution

    Here are the below link which gives the step by step of SQL commands

    I prefere u can go through once, so that you will understand clearly.

    Author Closing Comment

    thank you for tutorials

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now