Mikael Eriksson

[Bug]: Output parameter is null when capturing rows from procedure to table

1

### What happened? Output parameter from a procedure does not get a new value when inserting rows returned from the procedure to a table. ``` create procedure P @RC int...

[Bug]: Table variable naming conflict with internal table names

1

### What happened? Having a table variable that generates the same internal name as another declared table variable name does not work. First execution: ``` -- Internal name @t_0 declare...

[Bug]: Insert into from procedure fails with nested procedures and output parameters

1

### What happened? Insert the result to table from a procedure that in turn calls another procedure that uses output parameters fails if the second procedure does not also return...

[Bug]: Computed string column gives unmapped error

3

### What happened? Compute a string value for a computed column does not work. ``` create table T(C as N'X' + N'Y'); ``` Result: ``` Msg 33557097, Level 16, State...

### What happened? You get a syntax error if you try to insert the result from a stored procedure to a table and at the same time capture the result...

[Bug]: INSERT INTO from procedure does not care about column specification

1

### What happened? The syntax for insert into allows for specifying in what columns in the target table should be populated. Here the columns are populated left to right. ```...

### What happened? Comparing different integer types in `sql_variant` does not work as expected when using `intersect` and `except`. Note that it works as expected using `union` and `union all`....

### What happened? There is a crash when using dynamic sql with `sql_variant` parameters on the second execution of the dynamic SQL in a batch. Works fine for `union all`...