• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

sql server

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
0
rgb192
Asked:
rgb192
5 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
you need to do an update operation if you need the change to be persistant

update orders
set name = 'newname'
where orderid ='704'
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
tigin44Commented:
update O
set name = 'newname'
from orders O
where orderid ='704'
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
KinjalKumar PatelSenior Software EngineerCommented:
There are many resources posted on the web related to SQL.

Some of them are :

http://www.w3schools.com/SQl/default.asp
http://www.sqlcourse.com/
http://www.sql-tutorial.net/
http://sqlzoo.net/

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.

Thanks
0
 
sureshchsahuCommented:
Here are the below link which gives the step by step of SQL commands

http://www.sqlcommands.net/

I prefere u can go through once, so that you will understand clearly.
0
 
rgb192Author Commented:
thank you for tutorials
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now