Tell me more ×

Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

RAND in T-sql function

up vote 0 down vote favorite

Can any one tell why t-sql not allowing using RAND function in side a function

SELECT  CAST (RAND() * 10000000 as varchar(20))

the error is

Invalid use of a side-effecting operator 'rand' within a function.

edited Jan 23 at 5:36

marc_s
3,04711125

asked Jan 22 at 21:40

kumar_2002
1676

Have a look at Creating Nondeterministic functions in SQL Server using RAND() – Mikael Eriksson Jan 22 at 21:44

What version of SQL are you using? It works just fine on my SQL Server 2008 R2 instance. – mrdenny♦ Jan 22 at 22:12

we use mssql 2008 enterprise edition – kumar_2002 Jan 22 at 22:13

can you post the whole function? – AlexKuznetsov Jan 23 at 1:59

I'm not sure what Denny was trying; I get the same error on my 2008 R2 instance when putting that code in a function definition. – Jon Seigel Jan 23 at 3:30

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

Sign up or log in

Post as a guest

Name

Email required, but not shown

Post as a guest

Name

Email required, but not shown

discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged sql-server-2008 sql t-sql or ask your own question.

question feed

asked	3 months ago
viewed	118 times

RAND in T-sql function

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

Sign up or log in

Post as a guest

Browse other questions tagged sql-server-2008 sql t-sql or ask your own question.

Community Bulletin

Related