jeudi 6 août 2015

SQL Server: Update a colum with Random Value

I have a table Product and I have a column in it callled Genre which has null/unwanted values.

I want to update that colum with a set of values (Documentary,Comedy,Adventure/Action,Drama,Thriller,SF/Fantasy,Animation/Family ,Others)

The update can be in any order but I want every row in the column updated. How should I go about this?




Aucun commentaire:

Enregistrer un commentaire