Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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