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()
About Me
- Steven Luck
- Is an ordinary man, with a little knowledge to share and high dreams to achieve. I'd be glad if I can help others, 'coz the only thing for the triumph of evil is for a good man to do nothing.
Popular Posts
-
Have just got a lovely blog award, my second one, from a friend, Mona ^^ But there is a rule to accept this award.. hehehe... Post it on yo... -
Error: Creation of the virtual directory http://localhost/web failed with error: Could not find the server 'http://localhost' on the... -
Are you learning Assembly language , and confused about how to compile assembly file? TASM20 is one of assembly compilers that works with ... -
If you are trying to update a table containing XML column via Linked Server in SQL Server, and you are not able to, you are not alone. There...
-
Error: Error converting data type int to nvarchar This error occurs when a stored procedure which returns a value is used. e.g CREATE P...
0 comments:
Post a Comment