Answer the question
In order to leave comments, you need to log in
How to move a column from one table to another MS SQL?
There are 2 tables: It is
necessary from the 1st table to transfer several columns to the 2nd table.
I'm trying to do this (but it gives an error):
USE WorldSkills;/*Название БД, dbo.Import - первая таблица, dbo.Staff - вторая таблица*/
INSERT INTO dbo.Import SELECT
FirstName,
LastName,
DateOfBrith,
Gender,
Email,
Comments
FROM dbo.Staff;
GO
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question