newid() inside sql server function

by

here’s a clever solution:

create view getNewID as select newid() as new_id

create function myfunction ()
returns uniqueidentifier
as begin
   return (select new_id from getNewID)
end

that i can’t take credit for. i found it here:
http://omnibuzz-sql.blogspot.com/2006/07/accessing-non-deterministic-functions.html

-don

More Related Contents:

  1. “order by newid()” – how does it work?
  2. How do I search an SQL Server database for a string?
  3. How to add custom attributes to SQL connection string?
  4. How do I generate a random number for each row in a T-SQL select?
  5. Auto increment primary key in SQL Server Management Studio 2012
  6. SQL Server Linked Server Example Query
  7. Combine multiple results in a subquery into a single comma-separated value
  8. Infinite loop CTE with OPTION (maxrecursion 0)
  9. SQL Server IN vs. EXISTS Performance
  10. Floor a date in SQL server
  11. PIVOT in sql 2005
  12. How to run the same query on all the databases on an instance?
  13. Atomic UPSERT in SQL Server 2005
  14. How FOR XML PATH(”) works when concatenating rows
  15. SSRS 2014 report deploy issue
  16. Set start value for column with autoincrement
  17. What are named pipes?
  18. BULK INSERT with identity (auto-increment) column
  19. How to update primary key
  20. Making an Entity Framework Model span multiple databases
  21. SQL Server 2008 Row Insert and Update timestamps
  22. Should I index a bit field in SQL Server?
  23. Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
  24. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  25. Escaping single quote in SQL Server
  26. How to set value to variable using ‘execute’ in t-sql?
  27. Taking the second last row with only one select in SQL Server?
  28. What is the difference between Cartesian product and cross join?
  29. How to Bulk Insert from XLSX file extension?
  30. Count number of records returned by group by

Leave a Comment