SQL Server Random Password: Invalid use of a side-effecting operator NEWID within a function.
Invalid use of a side-effecting operator "newid" within a function.
Unfortunately you can not use the NEWID() funtion within a SQL Server funtion. One brilliant solution to this case is to use a predefined view with
create view v_getNewID as select newid() as new_id , 0 as tmp
go
select top 16 number as n from master..spt_values
where
type='p'
order by (SELECT [New_Id] FROM v_GetNewID)
go
In my case i used this script to randomly generate Password within sql server
Unfortunately you can not use the NEWID() funtion within a SQL Server funtion. One brilliant solution to this case is to use a predefined view with
create view v_getNewID as select newid() as new_id , 0 as tmp
go
select top 16 number as n from master..spt_values
where
type='p'
order by (SELECT [New_Id] FROM v_GetNewID)
go
In my case i used this script to randomly generate Password within sql server
Comments
Write the first comment
Leave a trace
Post being viewed right now
