writing a row to a table on another database server + identity column - Microsoft SQL / MS SQL Server

[praveen]

Steve,

In the Insert statemnt, explicitly specify the column names.


some thing like
Insert into [myserver].mysales.dbo.[myco_daily_orders]
(ord_date,ytd_total_qty,....)
Select .......



HTH
Praveen Maddali,
MCSD, MCDBA


"Steve Chatham" <com> wrote in message
news:uGLbjh#phx.gbl... 
ord_type 
defined 
using 
table 
the 
to 
same 

[Jens]

Hello Steve !

DIdn´t counted the values you want to insert but either you have to much are
too few column in the Values to enter (And Rember, you can´t enter a
identitiy without explicit specifying to insert it) If you don´t specify the
columns in the the target table you have to enter a value for both even IF
it is DEFAULT.

Jens Süßmeyer

[Steve]

Assuming my first column (the identity column) is called "ID", would I then
have my statement read:

Insert into [myserver].mysales.dbo.[myco_daily_orders]
(ID, ord_date, ytd_total_qty,.....)
Select
and then what do I need to put for the ID field? If I explicityly specify
the column names, and it is an identity column, what do i need to put in the
select statement in order to put the next value into it?

would select be:

Select
id
whatever--ord-date-is,
whatever-ytd-total-quantity-is
or would ID be left out?

Steve


"praveen" <stph.net> wrote in message
news:%23VDBvn%phx.gbl... [/ref]
ord_type [/ref]
ord_type [/ref]
ord_type [/ref]
ord_type [/ref]
ord_type [/ref]
ord_type [/ref]
ord_type [/ref]
ord_type [/ref]
ord_type [/ref]
ord_type [/ref]
ord_type [/ref]
ord_type 
> ord_type 
> defined 
> using 
> table 
> the [/ref]
it 
> same 
>
>[/ref]

[praveen]

Steve,

Since the first column in your destination table is a Identity column , you
can't insert values into that ( unless you have SET IDENTITY_INSERT ON for
the table).

So in the insert columns list specify all the columns in order except ID.
Keep your select statement as it is.



Insert into [myserver].mysales.dbo.[myco_daily_orders]
(ord_date,ytd_total_qty,....)
Select ord_date, ytd_total_qty
.................................................

Praveen
MCSD, MCBA

"Steve Chatham" <com> wrote in message
news:uDgXkv#phx.gbl... 
then 
the [/ref]
> ord_type [/ref]
> ord_type [/ref]
> ord_type [/ref]
> ord_type [/ref]
> ord_type [/ref]
> ord_type [/ref]
> ord_type [/ref]
> ord_type [/ref]
> ord_type [/ref]
> ord_type [/ref]
> ord_type [/ref]
> ord_type 
> > ord_type 
> > defined 
> > using 
> > table [/ref][/ref]
on [/ref]
> it [/ref][/ref]
the 
> >
> >[/ref]
>
>[/ref]

[Steve]

That was it.

Thank you for answering my question and for the clarification, also.

Steve


"praveen" <stph.net> wrote in message
news:efHZW%23%phx.gbl... 
you 
> then [/ref]
specify 
> the 
> > ord_type 
> > ord_type 
> > ord_type 
> > ord_type 
> > ord_type 
> > ord_type 
> > ord_type 
> > ord_type [/ref][/ref]
orders 
> > ord_type 
> > ord_type [/ref][/ref]
orders 
> > ord_type 
> > ord_type [/ref][/ref]
table [/ref][/ref]
match [/ref]
> on [/ref][/ref]
causing [/ref]
> the 
> >
> >[/ref]
>
>[/ref]