AFAIK has nocache something to do with generating sequences. So my best bet would be, there is no direct equivalent. However, something like the IDENTITY function might prove useful at times. Here's is maybe also interesting link about migrating Oracle to SQL Server:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]