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 regard datatype then use below query to change datatype of column
Syntax: ALTER TABLE Table_Name ALTER COLUMN Column_Name Datatype;
where data type is INT, Varchar, nvarchar, Real etc.
ALTER TABLE [ELNetDB_ratan].[dbo].[PPS_Customer] ALTER COLUMN MeterVer REAL;
Related Articles
Article 3.6.1T : How to copy SQL Data from one table to another table ?
1. SET NOCOUNT ON SET STATISTICS TIME ON INSERT INTO Table_name_one ( colm1, colm2, colm3, colm4, colm5 ) SELECT colm1, colm2, colm3, colm4, colm5, FROM Table_name_two SET STATISTICS TIME OFF SET NOCOUNT OFF Note: Before ...
Article 3.6.1AG : Update query for changing one column data to other column
Please refer the attached document, If a reading is recorded in another column due to wrong config, we can use the query to migrate the data from one column to other
Article 4.5.1A : Data pack required for GPRS communication
Please find the attachment of the data pack details.
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
Article 4.9.1A : Why each folder is created per day rather than in one folder ?
Q : The data is getting stored as one folder per day and NOT one folder for all day. So, the report can not be generated for the entire duration of the logging period. Our latest on site data logging was carried out with the help of your technical ...