----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: diniya25 Message 4 in Discussion RAND Returns a random *float* value from 0 through 1. Syntax RAND *( *[ /seed /] *) * Arguments /seed/ Is an integer expression (*tinyint*, *smallint*, or *int*) that gives the seed or start value. Return Types *float* Remarks Repetitive invocations of RAND() in a single query will produce the same value. Examples This example produces four different random numbers generated with the RAND function. |DECLARE @counter smallint SET @counter = 1 WHILE @counter < 5 BEGIN SELECT RAND(@counter) Random_Number SET NOCOUNT ON SET @counter = @counter + 1 SET NOCOUNT OFF END GO | Here is the result set: |Random_Number ------------------- 0.71359199321292355 (1 row(s) affected) Random_Number ------------------- 0.7136106261841817 (1 row(s) affected) Random_Number ------------------- 0.71362925915543995 (1 row(s) affected) Random_Number ------------------- 0.7136478921266981 (1 row(s) affected) | ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
