lundi 23 février 2015

SQL Server choose at random from giving data


My problem is that I don't know how to choose the random data from a giving set. For example: I have a Node column which need to produce different inserts but only from these numbers: 16, 17, 18, 22, 24. I have looked at many different posts but couldn't find what I'm looking for. Any tips, hints or very simple sample query would be much appreciate.


NOTE: I'm using SQL Server Management Studio 2014





Aucun commentaire:

Enregistrer un commentaire