MS SQL Issues
Good morning everyone. I have an SQL issue and I have no idea how to proceed. I have never worked with SQL and am working on SQL 2000. The database is a web database and I am trying to change the text. I easily changed the picture and the title, but the text column is and does not allow editing, how do I change the information? Thanks in advance.
timjpriebe posted this at 12:15 — 23rd August 2005.
He has: 2,667 posts
Joined: Dec 2004
Should be just like any other text field.
UPDATE tableName SET columnName = 'this is your new text' WHERE uniqueId=42;
Of course, you would fill in the names with your specifics, including replacing the 42. That's pretty standard SQL, so it should work no problem.
Tim
http://www.tandswebdesign.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.