Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Generic COUNT(*)

    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...

  • RE: Get NEWSEQUENTIALID

    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()))

    ...

  • RE: Get NEWSEQUENTIALID

    thanks a lot...

    "INSERT INTO @NewSequentialId DEFAULT VALUES;"

    actually i don't know i can use DEFAULT VALUES :)-

Viewing 3 posts - 1 through 3 (of 3 total)