SQL SERVER – Using RAND() in User Defined Functions (UDF)
- by pinaldave
Here is the question I received in email.
“Pinal,
I am writing a function where we need to generate random password. While writing T-SQL I faced following issue. Everytime I tried to use RAND() function in my User Defined Function I am getting following error:
Msg 443, Level 16, State 1, Procedure RandFn, Line 7
Invalid use of a side-effecting…