3.6 SQL queries
Article 3.6 SQL 2019 Installation Guide
Please find the attachment
Article 3.6.1AR : SQL Version Details Supported for Windows OS
Hi All, Please find the below link to check whether the selected version of SQL will support with the windows OS at any client location. https://docs.microsoft.com/en-us/troubleshoot/sql/general/use-sql-server-in-windows
Article 3.6.1AQ : SQL INSTALLATION ERROR Database Engine startup handle
ERROR WHILE INSTALLING SQL EXPRESS EDITION Could not find the Database Engine startup handle. SOLUTION: Reinstall the SQL with new setup of any versions by downloading, which will resolve the issue in installation failure.
Article 3.6.1AP : ELNET SERVICE STOPPED DUE TO DATABASE TIMELY FASHION ERROR
Dear All, Please find the attached document for timely fashion error with respect to SQL. Regards Jithin G.
Article 3.6.5S : How to check Server name and PW of SQL?
Yes, we can know the server name and Password of the SQL server management studio. With the help of ElNet master application is available in the software installation folder in the server PC program file. Click on ElNet master and we can know the SQL ...
Article 3.6.1AE : How to check Live Data in a SQL?
First, open the SQL server management studio (SSMS) and log in with the user id and password. After that follow below hierarchy to get Online data from SQL. ElNetDB > dbo.LiveData > Edit Top 200 Rows. You will find the table of the list of the meter ...
Article 3.6.2S : SQL Configuration manager already installed in PC for new ElNet installation.
As mention in the subject SQL server configuration manager is already installed in a PC of new ElNet software installation. But as I have checked on PC there is not an installed SQL server management studio (SSMS). customer is using SQL for account ...
Article 3.6.1AN: SQL ERROR ON DATABASE RESTORING
Attachment for reference
Article 3.6.1AM : SQL DATABASE ERROR (CONNECTION TO DB FAILED)
SQL DATABASE ERROR (CONNECTION TO DB FAILED)
Article 3.6.1AL : SQL ERROR while restart solution 2
SQL ERROR while restart solution 2
Article 3.6.1AK : SQL ERROR while restart solution 1
SQL ERROR while restart solution 1
Article 3.6.1AJ : Performance Hive Consistency Error While installing SQL
Pls Refer Attachment to resolve Performance Hive Registry Error While installing SQL
Article 3.6.1AI : Sql Server Configuration manager not getting opened error
Find the attachment for rectifying Sql Server Configuration manager not getting opened error
Article 3.6.1AH : How to Change Sql Server password using query
Please refer the attachment for changing password using query
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 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 3.6.1Z : HOW TO PROVIDE SQL READ/WRITE ONLY ACCESS IN DIFFERENT LOGIN
Pls find the attachment for the providing read/write access in different login
Article 3.6.1Y : HOW TO PROVIDE SQL READ ONLY ACCESS IN DIFFERENT LOGIN
Please refer the attachment
Article 3.6.1X : Why I couldn't restore ElnetDB in SQL?
We can always restore the DB in Same version or upgraded version of SQL (but not lower version). For example - If the backup is taken in SQL 2014, the backup file can be restored only in SQL 2014 or later but not in SQL 2008 or lower version. If the ...
Article 3.6.1W : How to solve Incorrect syntax near 's' when restoring DB.
When restoring DB, Incorrect syntax near 's' error will popup. To solve this, follow the below steps. Step 1 : Go to DB restore page (Select DB -> right click -> select Tasks -> Restore -> Database). Step 2 : Click options. Step 3 : Enable overwrite ...
Article 3.6.1V : SQL server express edition to standard upgradation details.
required details for Database storage up to 10 to 15 years with time interval of Data-log 15 min based on relation DB creation. Kindly go through below details for that : 1. Why to Upgrade. Reason: As per present SQL server running in your system is ...
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.1I : How to solve database startup error ?
1- If below mention error is coming in database 2019-06-03 11:43:07.64 spid4092 Recovery completed for database ELNet5Data58 (database ID 63) in 2 second(s) (analysis 1274 ms, redo 0 ms, undo 811 ms.) This is an informational message only. No user ...
Article 3.6.1J : How to take SQL backup using query ?
You can directly take backup using sql query. It will save your time for taking backup. BACKUP DATABASE [ELNetDB] TO DISK = 'D:\Alok\KB\Backup Sql\ELNetDB.bak'
Article 3.6.1E : How to resolve Data saving error in SQL ?
1. If your DB is showing error like arithmetic data over flow & data saving error. 2. It means one of your database has been corrupted. 3. You have to repair your DB. 4. First Run the below query to check error in database. DBCC ...
Article 3.6.1M : Data is not logging for few meters - Why & How to solve it?
Step 1 : First Check SQL database (i.e whether it is connected/online or not). Step 2 :If only few meters data are not logging, then database might be corrupted. Step 3 : Create a new database with a same name (delete/rename previous one), Step 4 : ...
Article 3.6.1S : How to fix Recovery Pending State in SQL Server Database?
Manual way to fix “SQL server recovery pending” state There are 2 manual ways to start Recovering Pending State in SQL Server database that has been marked in recovery pending state: Solution 1: Mark database in Emergency mode and initiate forceful ...
Article 3.6.1L : How to solve "Value cannot be null. Parameter name: viewinfo" when expanding database.
When expanding database its showing error of " Value cannot be null Parameter name: viewinfo (Microsoft.SqlServer.Management.SqlStudio.Explorer) Kindly follow the below steps: Open Run file using windows key + R Type %Temp% then Hit Enter Key. So ...
Article 3.6.1P : How to create PPS_CoilOpr table in ELNet DB ?
If recharge is not happening. Go to ELNet S/W root folder & Check ELNet Log Event here if you are finding any error like PPS_CoilOpr invalid. Open SQL Server & Check ELNet DB. If PPS_CoilOpr table is missing. Just copy below mention Query. USE ...
Article 3.6.1D : SQL UNINSTALLATION ERROR
Attached Document
Article 3.6.1G : How to open SQL server configuration manager in windows 8, 8.1, 10 ?
Kindly download the attached document.
Article 3.6.1F : How to identify SQL Instance name
Attached document to identify sql instance name
Article 3.6.1N : How to Check SQL Version and Edition using command and GUI ?
Attached document to check sql version and edition
Article 3.6.1Q : How to Delete & Shrink Record In SQL Database?
1. Why we need Delete query & Shrink Database? When the SQL stored No. of record in huge amount. There will be chance of Database crash & data lost. If the No. of record is log in every 1 min then the size of row will be increase in Table. If size of ...
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.6.1R : How to find the SQL Version (whether it is SQL Express or SQL Server).
Step 1 : Open SQL Configuration manager Step 2 : Right click SQL server (SQLEXPRESS) > Properties Step 3 : Go to advanced tab & scroll down. Step 4 : Find "Stock keeping unit name" Step 5 : It will show whether it is SQL Express edition or SQL server ...
Article 3.6.1H : How to Recover SQL Database from Suspect Mode?
Steps to Fix the SQL Server Database Suspect Mode Error Here are the steps to change ‘SQL database suspect mode to normal mode’ : Open SQL Server Management Studio and connect your database Select the New Query option Turn off the suspect flag on the ...
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 ...