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

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

Interpreter supports single select

Newsgroups microsoft.public.sqlserver.programming
Date 2016-02-19 08:08 -0800
Message-ID <97015ec1-d2aa-471c-813a-c14b036acd14@googlegroups.com> (permalink)
Subject Interpreter supports single select
From Jack Brosch <jbrosch58@gmail.com>

Show all headers | View raw

I'm working through a SQL interpreter that only allows one outer select command (sub-queries / unions are supported) and I'm trying to work around this ... any suggestions?

-- Works
Select *
	INTO TempJack
	FROM Sales.Customer

Select *
	From TempJack



-- Doesn't work
SELECT * FROM 
	( 
	SELECT * 
		INTO TempJack
		FROM Sales.Customer
	)

Back to microsoft.public.sqlserver.programming | Previous | Next — Next 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