Home Forums SQL Server 2008 SQL Server Newbies Stored Procedure to Add Details to a table RE: Stored Procedure to Add Details to a table

  • October 17, 2012 at 6:05 am

    #1549966

    CREATE PROCEDURE addDocDetail

    @detailID int = NULL,

    ...,

    ...

    AS

    SELECT @detailID = ISNULL(@detailID, IDENT_CURRENT('Doctor'))

    ...

    ...

    GO

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]