/*<\/span><\/div>Return a random TINYINT ( 0 - 255 )<\/span><\/div>usage : SELECT dbo.getRandomTinyint()<\/span><\/div> <\/div>
NOTE : This function is dependent on the VIEW<\/span><\/div>since you can't call RAND inside of a UDF()<\/span><\/div> <\/div>
-- BEGIN VIEW<\/span><\/div> -- This is only a helper VIEW since currently you can not use RAND() in a UDF<\/span><\/div> -- DROP VIEW vRand<\/span><\/div> CREATE VIEW [dbo].[vRand]<\/span><\/div> AS<\/span><\/div> SELECT RAND() AS 'number'<\/span><\/div>-- END VIEW<\/span><\/div> <\/div>
*/<\/span><\/div> <\/div>
<\/div>
IF<\/span> OBJECT_ID<\/span> (<\/span>N<\/span>'getRandomTinyint'<\/span>)<\/span> IS<\/span> NOT<\/span> NULL<\/span><\/div> DROP<\/span> FUNCTION<\/span> getRandomTinyint<\/span><\/div>GO<\/span><\/div> <\/div>
CREATE<\/span> FUNCTION<\/span> getRandomTinyint<\/span>()<\/span><\/div>RETURNS<\/span> tinyint<\/span><\/div>WITH<\/span> EXECUTE<\/span> AS<\/span> CALLER<\/span><\/div>AS<\/span><\/div>BEGIN<\/span><\/div>-------------------------------------------------------------------------------<\/span><\/div> DECLARE<\/span> @<\/span>max<\/span> TINYINT<\/span>,<\/span> <\/div> @<\/span>min<\/span> TINYINT<\/span>,<\/span> <\/div> @<\/span>rand<\/span> NUMERIC<\/span>(<\/span> 18<\/span>,<\/span>4<\/span> ),<\/span><\/div> @<\/span>out<\/span> TINYINT<\/span>;<\/span><\/div> <\/div>
-- set TINYINT parameters<\/span><\/div> SET<\/span> @<\/span>max<\/span> =<\/span> 255<\/span>;<\/span><\/div> SET<\/span> @<\/span>min<\/span> =<\/span> 0<\/span>;<\/span><\/div> -- get RAND() from VIEW since we can't use it in UDF<\/span><\/div> SELECT<\/span> @<\/span>rand<\/span> =<\/span> number<\/span> FROM<\/span> vRand<\/span><\/div> <\/div>
-- make the number<\/span><\/div> SELECT<\/span> @<\/span>out<\/span> =<\/span> CAST<\/span>(((<\/span>@<\/span>max<\/span> +<\/span> 1<\/span>)<\/span> -<\/span> @<\/span>min<\/span> )<\/span> *<\/span> @<\/span>rand<\/span> +<\/span> @<\/span>min<\/span> AS<\/span> TINYINT<\/span>);<\/span><\/div> <\/div>
-- pass it back<\/span><\/div> RETURN<\/span> @<\/span>out<\/span>;<\/span><\/div>-------------------------------------------------------------------------------<\/span><\/div>END<\/span>;<\/span><\/div>GO<\/span><\/div><\/pre><\/div>\n \n <\/div>\n\n