Home Forums SQL Server 2008 T-SQL (SS2K8) Update raise error RE: Update raise error

  • June 21, 2013 at 6:19 am

    #1626294

    Hi

    Did you try:

    UPDATE mytable SET mycol = 'new vlaue' WHERE 'col' = 'value'

    IF @@ROWCOUNT = 0

    RAISERROR('No rows updated',16,1)

    Regards

    Mike