Viewing 3 posts - 1 through 3 (of 3 total)
thanks all for the comments.
the use of the stored procedure 4 this solution might seem not so obvious but i do personally prefer sp instead of adhoc launched from data...
October 22, 2010 at 5:57 am
#1240837
Yes, that should be the right way to do.
Thanks gil.milbauer...
CREATE PROCEDURE dbo.sp_NewSequentialId
(@Id AS UNIQUEIDENTIFIER OUTPUT)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @NewSequentialId AS TABLE (Id UNIQUEIDENTIFIER DEFAULT(NEWSEQUENTIALID()))
...
October 19, 2010 at 2:43 pm
#1239354
thanks a lot...
"INSERT INTO @NewSequentialId DEFAULT VALUES;"
actually i don't know i can use DEFAULT VALUES :)-
October 19, 2010 at 2:06 pm
#1239320