How to using query to replicate table ?

Hi All,
Please advised how to using query update table, but I don't want to
clear table before updating.
It's hard to guess what you are asking here.
You can configure your articles while creating your publication to
leave the existing table intact without deleting any data.
To do this, create your publication using the wizard and when you get
to the specify articles dialog box, click on the browse button to the
right of your table, and then click on the snapshot tab.
Select Keep existing table unchanged.
Looking for a SQL Server replication book
http://www.nwsu.com/0974973602.htm
|||Hilary, I'm getting a "page not found" on your book link.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1112974572.789187.308300@.l41g2000cwc.googlegr oups.com...
> It's hard to guess what you are asking here.
> You can configure your articles while creating your publication to
> leave the existing table intact without deleting any data.
> To do this, create your publication using the wizard and when you get
> to the specify articles dialog box, click on the browse button to the
> right of your table, and then click on the snapshot tab.
> Select Keep existing table unchanged.
> --
> Looking for a SQL Server replication book
> http://www.nwsu.com/0974973602.htm
>
|||its html not htm - not sure how that happened.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com