-----Original Message-----
From: Terry Collins
[mailto:oracledba-ezmlmshield-x53114938.[Email address protected]
Sent: Tuesday, April 03, 2007 2:39 AM
To: LazyDBA Discussion
Subject: Re: insert statement help MSSQL

Sorry forgot to add:

into the same field. we are trying to create a text file with 5 columns
that are a combination of text and fields from another table.

Paul Blosser wrote:

> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address as
normal
> **Anything below this line is the original email text
>
>
> Yes -- something like this:
> Insert into my_table
> (text_column1, date_column2)
> Values
> (select 'Col1Val' ,sysdate from dual);
>
> Paul Blosser
> System Developer
> Abanco Int'l, LLC.
> 847-227-2301x2421
>
> -----Original Message-----
> From: Terry Collins
> [Email address protected]
> Sent: Monday, April 02, 2007 3:52 PM
> To: LazyDBA Discussion
> Subject: insert statement help MSSQL
>
> Can I mix text values and field (select query returned) values in an
> insert statement?
>

--
Terry Collins
LAN Administrator
Health Service
Eastern Illinois University
(217) 581-7015



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page