Oops 🙂 Your right... it's way too early in the morning...

declare @myothertab table (

col2 varchar(20),

col3 varchar(20)

)

insert into @myothertab

select 'A','B' union all

SELECT 'W','Q'

;

declare @myanothertab table (

col2 varchar(20),

col3 varchar(20)

)

insert into @myothertab

select 'A','B' union all

SELECT 'W','Q';

select 1 as col1, col2, col3 into #mytmp

...

Doesn't work for me. I have to hold down the ctrl-key + left-click.

Which capabilities is CAST missing when it "has less capabilities in SQL Server"?

Don't know what happened there. I recreated the database and everything works now 🙂 (Gremlins?)

I'm not sure what you mean. The command I got from the profiler is the first one in my first post. As I said, this command is generated by the...

No, your suggested command has the same result as the auto generated one, an empty table.

This looks like there is something missing to sp_executesql or the target procedure in terms...

That statement is generated by System.Data.Common.DbCommand, you cannot modify it.

After rebuilding the index I also get a table scan on querie 1.

Now that's interesting. I filled "t" with your script. Including my initial data, there are 10288 rows. I ran the four queries and still get the only table scan on...

Can you explain what you mean with "Also, your statement is only true for the small number of rows..."?

I ran both your example and that from the question. On all...