Transfer the data
of an existing column to another column via SQL command
SQL script
|
USE [Demo]
GO
UPDATE tblTest
SET [NewColumn] = IDTest
GO
|
Use the UPDATE
table SET command Ziel_Feld = Quelle_Feld
The data is
transferred.
The field must be
of the same type as here of type INT
Show table
SQL SErver
script to display
the table in SQL Server
|
/****** script for SelectTopNRows
command from SSMS ******/
SELECT TOP (1000) [IDTest]
,[Test]
,[NewColumn]
FROM [Demo].[dbo].[tblTest]
|