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 |
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
 Posted - 2011-03-02 : 09:14:55
|
| Iam getting an error when I am trying to delete a single column record from a table.DELETEtrigid FROM REQNOWHERE requestid = 789654triagedt is a column in the REQNO tableError Message that I have been gettingMsg 208, Level 16, State 1, Line 1Invalid object name 'triagedt'. |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-03-02 : 09:33:23
|
| are you trying to drop a column from a table or remove all records from a table where requestid = 789654? Are you trying to update a column's values to nulls?JimEveryday I learn something that somebody else already knew |
 |
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2011-03-02 : 09:41:40
|
| Iam trying to delete triagedt column value from REQNO Table where the requestid = 789654The REQNO Table has several other columns and it only has 1 row of data for the requestid 789654Thanks |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-03-02 : 09:59:10
|
| Okay, still not sure I'm following, but I think you want to update the value in the triagedt column in the RECNO table where requestid = 789654. If that is true:UPDATE RECNOSET triagedt = nullWHERE requestid = 789654JimEveryday I learn something that somebody else already knew |
|
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2011-03-02 : 10:26:06
|
| GreatWhy on Earth was I not thinking to update it and just trying to deleteThanks Much |
|
|
|
|
|
|
Deleting single column record from a table