Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: fostc
  • Order by date
  1. fostc

    Finding an alternative to the IDENTITY Function

    There is a larger stored procedure which calls a number of views and I am just replacing one of those. If I am unable to find an alternative then I will have to add my code to this procedure but I would rather keep things consistent as I will have to amend a number of procedures rather than 1...
  2. fostc

    Finding an alternative to the IDENTITY Function

    We're using SQL Server 2000 - any other ideas?
  3. fostc

    Finding an alternative to the IDENTITY Function

    I've got a Stored Procedure that is working fine using the IDENTITY function, but now need to create a VIEW instead. As I am unable to create temporary tables within the view, is there an alternative function for me to use that does the same as IDENTITY?

Part and Inventory Search

Back
Top