They run just fine from a .SQL dialog from VS2015, but not within a SQL unit-test.
In all cases I am populating a temp table and using MSSQL 2015.
This standard syntax works just fine in both a SQL unit-test and as a SQL script in DevStudio;
Expand|Select|Wrap|Line Numbers
- INSERT INTO #Expect ([Name], [System_Type_Name]) VALUES ('Mail_Option', 'Varchar(20)'
Expand|Select|Wrap|Line Numbers
- SELECT * INTO #Actual FROM OPENROWSET('sqlncli', 'server=xxx;Trusted_Connection=yes;','EXEC xxx')
Expand|Select|Wrap|Line Numbers
- INSERT INTO #Actual EXEC dbo.Xxx
Expand|Select|Wrap|Line Numbers
- System.Data.SqlClient.SqlException: Incorrect syntax near the word 'INTO'.