SqlServer 全域變數

標籤：style   blog   color   使用   strong   io   cti   div   

1、@@ERROR 

返與@@ERROR 近語句錯誤碼局限於DML語句select語句執行現錯誤則返等於0錯誤碼沒錯則返0通使用判斷語句沒執行功

-- Create Schema if not one exists with same name and owner    set @stmtS = ‘create schema ‘    set @stmtS = @stmtS + quotename(@rolename, ‘]‘)    set @stmtS = @stmtS + ‘ authorization ‘    set @stmtS = @stmtS + quotename(@rolename, ‘]‘)        BEGIN TRANSACTION    -- issue DDL to create the role --    exec (@stmtR)        if @@error <> 0    begin        ROLLBACK TRANSACTION        return (1)    end