Select statement result change as insert statement values

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246985 More actions · Answer 1

SELECT ID
      ,Name = CONCAT ('''', Name, '''')
      ,City = CONCAT ('''', City, '''')
FROM #tbl_Test;

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Jonathan AC Roberts SSCoach Points: 18361 More actions · Answer 2

Phil Parkin wrote:

SELECT ID
      ,Name = CONCAT ('''', Name, '''')
      ,City = CONCAT ('''', City, '''')
FROM #tbl_Test;

Or even simpler if you have a lot of tables to do it for:

DECLARE @Quote varchar(100) = ''''
SELECT ID
      ,Name = CONCAT (@Quote, Name, @Quote)
      ,City = CONCAT (@Quote, City, @Quote)
FROM #tbl_Test;

Saran Right there with Babe Points: 760 More actions · Answer 3

Sorry, missed the comma.

Result should be - 1 ,'A','US'

insert into #tbl_Test values (1 ,'A','US')

Phil Parkin SSC Guru Points: 246985 More actions · Answer 4

Do you want a single-cell result, rather than multiple columns?

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Saran Right there with Babe Points: 760 More actions · Answer 5

I just need first line or row from the table. That I am going to copy and put it in insert statement to insert to table.

Jonathan AC Roberts SSCoach Points: 18361 More actions · Answer 6

If you look at this post there is a stored procedure that will generate the inserts for any table: https://www.sqlservercentral.com/forums/topic/generate-script-for-table-contents#post-4184688

Just install it and call it:

EXEC INFGenerateInserts @table_name='#tbl_Test';

Saran Right there with Babe Points: 760 More actions · Answer 7

Thank you Jonathan AC Roberts.

It is working amazing.