Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#

 

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

Ein Bild, das Text enthält.
Automatisch generierte Beschreibung

 

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]

 

Mobile

.

Contact for Jobs, Project Requests: raimund.popp@microsoft-programmierer.de