Hi guys,
i need to change (i guess update) the value on a specific row depending on the value of another row. Let me be more clear.
i have values in code rows and i have a choise box with actif and inactif named member
I need to set member to actif if there is any type of value in code. i have over 700 to change the value i dont want to do them manually.
Can someone help
...
sethupathy22
Last Activity: Apr 21 '08, 02:10 PM
Joined: Feb 5 '08
Location:
-
Basic MSSQL Query help
-
Transfer mysql DB to MS SQL help
Can someone help on on a tranfer from mysql to mssql any tutorials and tools
would be much appreciated
(from an extracted file)
Thanks a bunch -
Thanks in worked , and thanks for the line
WHERE Pers_statut IS NULL
i forgot that i have modified some manually
SOLVED... -
Basic MSSQL Query help
Hi guys ,
i have a basic query question, sorry i am not familiar with all the terms so bare with me
i have a table called Persons and a row called Pers_statut which is a choise box (Active and Inactive) i want to set everyone to Active
i thought this would work but didnt
UPDATE Persons
SET Pers_statut = 'Active'
WHERE Pers_statut = ' '
when i execute i...
No activity results to display
Leave a comment: