Member Avatar for bettybarnes

hi just wondering how do i transfer table's records to another table??
i'm wondering where do i put the queries, or am i gonna put it in my stored proc?

any help will help

thanks

  • 3 Contributors
  • 3 Replies
  • 86 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by Pgmer
Member Avatar for Pgmer

Using Query ony u want to it? cant u use import export wizard to do that?

Member Avatar for kvprajapati

You can use INSERT and SELECT sql statement in one query.

Member Avatar for Pgmer

Ya Adatapost, Its nice way actually.. Sorry i forgot that.:)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.