Member Avatar for harcaype

Hi. Can anyone tell me how to copy data from a table from another database? I was able to copy but I only got the columns and not the data it contains.

This is how I copied it:
I tried this first:

USE MMDA
GO
SELECT * INTO MMDAserver.Vio.ViolationList FROM ViolationList

then when I was able to copy the columns from there I tried this one next. However it still didn't add anything. The columns are still empty.

INSERT INTO MMDAserver.Vio.ViolationList (ViolationCode,ViolationD,FineAmnt) 
SELECT * FROM ViolationList
Edited by Reverend Jim because: Fixed formatting
  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by boblarson
Member Avatar for boblarson

I personally have always used a DTS package to do this (SQL Server 2000)

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.