Write an efficient stored procedure to allocate unique integer ids.

Question

Sigiloso · Accepted Answer

CREATEPROCEDURE [dbo].[AllocateUniqueIntIds] 
AS
BEGIN
SelectABS(CAST(CAST(NEWID()ASVARBINARY(5))ASBigint))as UniqueIntegerId  
END
Go
/* Test the store proc */
Exec [dbo].[AllocateUniqueIntIds]

//Not sure if this is the correct answer

Two Sigma

Pergunta de entrevista da empresa Two Sigma

Resposta da entrevista

Empresas seguidas

Buscas de vagas