Loading ...

Invalid use of side-effecting or time-dependent operator in 'rand' within a function.

Who is online?  0 guests and 0 members
home  »  forums   »  asp.net topics   »  data access   » Invalid use of side-effecting or time-dependent operator in 'rand' within a function.

Invalid use of side-effecting or time-dependent operator in 'rand' within a function.

Posts under the topic: Invalid use of side-effecting or time-dependent operator in 'rand' within a function.

Posted: 5/13/2010

GeorgeK56
George K
Lurker 50  points  Lurker
  • Joined on: 3/28/2010
  • Posts: 10

Hi,

 

I am trying to execute rand() function in my user defined function but I am recieving "Invalid use of side-effecting or time-dependent operator in 'rand' within a function."

Please help me.


tags sql

Posted: 5/16/2010

raghav_khunger
Raghav Khunger
Guru 16813  points  Guru
  • Joined on: 4/19/2009
  • Posts: 490
  Answered

Please read this http://codeasp.net/blogs/raghav_khunger/microsoft-net/712/generate-n-digit-alphanumeric-string-in-sql . I have given the solution in it.


tags SQL
<b>[<a href="https://mvp.support.microsoft.com/profile/Raghav">ASP.NET MVP</a>]  [<a href="https://www.microsoftcommunitycontributor.com">Microsoft® Community Contributor</a>] [<a href="http://www.dzone.com/aboutmvb">Dzone MVB</a>] [<a href="https://twitter.com/#!/RaghavKhunger">Follow me on Twitter</a>]</b> <br/><br/><b>[<a href="http://codeasp.net/wiki/view/10/how-to-ask-questions-on-forums">How to ask questions on forums</a>]</b> <br/><br/> "Success does not come to those who wait . . . and it does not wait for anyone to come to it." Anonymous <br/> "Success is simply a matter of luck. Ask any failure." Anonymous
Page 1 of 1 (2 items)