Monday, October 18, 2010

Copy all Data From one Table to another with same Structure in sql

copy all Data From one Table to another  with same Structure

insert into [MyDB].[dbo].[Emp] select * from [Info].[dbo].[A]

it will copy all data in EMP table from A Table
-
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Mat Table Angular

Mat Table in Angular Mat table is used to display data . its a material designed styled data-table . For using Material Table MatTableMo...

  • Apply Criteria on XPCollection
    CriteriaOperator criteria = new BinaryOperator("Age", 30, BinaryOperatorType.Greater); CriteriaOperator criteria = CriteriaOperato...
  • How To Sort a XPCollection
    SortingCollection sc = new SortingCollection(); sc.Add (new SortProperty("field on which you want to sort",DevExpress.Xpo.DB.Sorti...
  • Angular Build Minification and Uglification
    Minification and Uglyfication in Angular Deployement Minification : While building Angular Application white spaces , unused variable , u...