Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Shep
Starting Member
19 Posts |
 Posted - 2013-07-15 : 15:07:22
|
| I have to do an simple update and delete in a project for school.I need FAST help bc I forgot this was due tonight.So what I want to do is have 2 textboxs. Named txtEmpID, txtPhoneThe user types in the info an it updates the database with the phonenumber when the button is clickedAlso, Another button that will delete the row selected by the txtEmpID.Someone PLEASE give me the code for this.When I get off work, I will only have 1 hour to get this into my laptop before I have to go to class.Thanks,Shep |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-16 : 01:31:14
|
| whats the application you're using? you need some code in application to formulate query based on your selection and then query it against database. So unless you specify application language we cant even suggest a referenceFrom SQL perspective, this requires a simple update and delete queries with filter condition based on EMpIDhttp://www.w3schools.com/sql/sql_update.asphttp://www.w3schools.com/sql/sql_delete.asp------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
SQL update and Delete