Article 3.6.1AG : Update query for changing one column data to other column

• Related Articles

• Article 3.6.1O : How to copy one column data to another column in a same table ?

  Use below query to copy one column to another column. Syntax: UPDATE Table_Name SET[COLUMN1]=(COLUMN2) WHERE '%CONNDITON%'; UPDATE [ELNetDB_ratan].[dbo].[PPS_Customer] SET[MeterVer]=(Area) WHERE MeterVer='0'; If above query is showing any error ...

• Article 3.6.1AD: In SQL, how to clear all the rows in one query?

  If you want to delete all the rows in a table, use the below command. Click new query and type this command - truncate table "TableName". FYR - Kindly have a look at the attached image.

• Article 4.5.1A : Data pack required for GPRS communication

  Please find the attachment of the data pack details.

• Article 3.6.1K : How to update SQL Data with given Time period for single meter ?

    SELECT*   FROM [Database_Name].[dbo].[Table_Name] WHERE Column_Name='XYZ' AND ScanTime BETWEEN '2016-11-01 00:00:01' AND '2016-11-30 23:59:59'    UPDATE[Database_Name].[dbo].[Table_Name] SET[Column_Name2]='2' Column_Name='XYZ' AND ScanTime BETWEEN ...

• Article 3.5.1A : EN/PN - Data Logger - Version 4 - Software

  For EN/PN above version 04.07, this updated software should be used to download the data. Click this link for software download page, http://www.elmeasure.com/resources/software