1>select @@error
1>;
|
|-----------
|          0

(1 row affected)
1>exec("thi should cause an error") select @@error
1>;
Msg 102, Level 15, State 1
Server 'roo', Line 1
Incorrect syntax near 'cause'.
|
|-----------
|        102

(1 row affected)
1>exec("thi should cause an error") select @@error;
Msg 102, Level 15, State 1
Server 'roo', Line 1
Incorrect syntax near 'cause'.
|
|-----------
|        102

(1 row affected)
1>exec("select 1") select @@error;
|
|-----------
|          1

(1 row affected)

|
|-----------
|          0

(1 row affected)
1>exec("select 1/0") select @@error;
Divide by zero occurred.
|
|-----------
1>exec("select 1/a") select @@error;
Msg 207, Level 16, State 4
Server 'roo', Line 1
Invalid column name 'a'.
|
|-----------
|        207

(1 row affected)
1>