Post reply

What is wrong with the sql statement

  • September 2, 2009 at 8:25 am

    #134892

    Create PROCEDURE [dbo].[SRIP_Contracts]

    @Contract_ID varchar(100)

    AS

    IF @Contract_ID IS NULL

    BEGIN

    set Convert(uniqueidentifier, @Contract_ID) = NEWID()

    INSERT INTO dbo.tblContracts

    (Contract_ID)

    Values (@Contract_ID)

    End

  • September 2, 2009 at 8:28 am

    #1048185

    At a guess...

    set Convert(uniqueidentifier, @Contract_ID) = NEWID()

    should be

    set @ContactId = Convert(varchar(100), NEWID() )


    Clear Sky SQL
    My Blog[/url]

  • September 2, 2009 at 8:43 am

    #1048198

    Thank you. It worked.

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

You must be logged in to reply to this topic. Login to reply