如何从数据库中随机选择检索图像?
问题描述:
嗨.我可以随机选择从数据库表中检索图像吗?因为现在我只能检索,但不能随机选择.
Hi. May I know how do I retrieve images from database table at a random pick. Cause right now I can only retrieve but not at a random pick. May I know how to do that?
答
SELECT TOP 1 *
FROM MyImageTable
ORDER BY NEWID()
应该可以!
That should work!