No More Solutions

You can find a lot of debugging and deploying problems while developing applications in .NET and Visual Basic here. There are also some querying tips in SQL and typical source codes which might be useful shared here.

Generate random characters

There is a way to generate random characters in a simple way, just use :
select NEWID()


This function is quite useful in some occasions, though may not be it's main usage.
e.g. If you're going to generate a random quote from a table named MsQuote :
SELECT TOP 1 QuoteId, QuoteText
FROM MsQuote
ORDER BY NEWID()
Bookmark and Share

0 comments:

Post a Comment