I have a table in MS SQL that has a field called "password" (text field) that I need to add random data to any fields that are NULL for all records in table.
I was thinking of having a number ie 1 and then for the next null field do the number +1.
so 1, 2, 3, 4 till EOF
What SQL statement can I use that will place a number while incrementing by 1 to all null values in the Password field(text field)?
Thanks for your help