Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.sqlserver.programming > #31290

Re: Interpreter supports single select

Show all headers | View raw

Jack Brosch (jbrosch58@gmail.com) writes:
> -- Doesn't work
> SELECT * FROM 
>      ( 
>      SELECT * 
>           INTO TempJack
>           FROM Sales.Customer
>      )
> 

You can only use the INTO clause in the outermost SELECT, so the above is
not legal. On top of that, you need an alias for the derived table.

SELECT * INTO TempJack FROM 
	( 
	SELECT * 
		INTO TempJack
		FROM Sales.Customer
	) AS c


-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous in thread | Find similar

Thread

Interpreter supports single select Jack Brosch <jbrosch58@gmail.com> - 2016-02-19 08:08 -0800
  Re: Interpreter supports single select Erland Sommarskog <esquel@sommarskog.se> - 2016-02-19 21:44 +0100

csiph-web