SQL Server Global Variables

1, @ @ERROR

Back with @ @ERROR near statement error Code limited to DML statement SELECT statement execution now error return equals 0 error code yes then 0 pass use Judgment statement did not perform

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