MySQL Could not load assembly MySQL-Generating Row Number for each row Thank you for landing here In a development work environment as a developer or database administrator may expect the query results to have sequential number or running number like 1,2,3,4, etc for each row . There are databases have their own way of handlingContinue reading “MySQL – Generating Row Number for Each Row”
Tag Archives: SQL
How to find second highest value in table ?
How to find second highest value in table ? SQL Server Find the highest employee salary SELECT EmpId, SalaryFROM(Select EmpId, Salary, ROW_NUMBER() OVER(ORDER BY Salary Desc) AS Salary_OrderFROM Employee) resultsWHERE results. Salary_Order = 1 ; Find the 2nd highest employee salary SELECT EmpId, SalaryFROM(Select EmpId, Salary, ROW_NUMBER() OVER(ORDER BY Salary Desc) AS Salary_OrderFROM Continue reading “How to find second highest value in table ?”
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
How to fix Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding Finding Root Cause: When using MySQL database and .NET /Connector with a thousands of rows to do an INSERT IGNORE command results in timeout expired exception. Usually we tend to suspect on the connectionContinue reading “Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.”
How to download Adventure Works 2014 Sample Database ?
AdventureWorks 2014 for SQL Server 2014 has been released and is ready for download, [link]. The sample includes various flavors of samples that you can use with SQL Server 2014, and are:1. OLTP Database2. DW Database3. Tabular Model Database4. Multi Dimensional Model Database https://archive.codeplex.com/?p=msftdbprodsamples
Install the Google Publisher Toolbar
(adsbygoogle = window.adsbygoogle || []).push({ google_ad_client: “ca-pub-9111247652808147”, enable_page_level_ads: true }); Google Publisher Toolbar To use the Google Publisher Toolbar you’ll need to install it and allow it access to the Google Account associated with your account. Browse to the Google Publisher Toolbar (by Google) page. Click Add to Chrome. In the dialog that appears, click Add Extension. The GoogleContinue reading “Install the Google Publisher Toolbar”
How to find first and last occurrence of any char or word in sql query?
How to find first and last occurrence of any char or word in sql query? Find First occurrence of any character or word in the string : In the given below example, we need to search for the first occurrence of word ‘the’ in the sentence. DECLARE @String AS VARCHAR(100) DECLARE @strSearch AS VARCHAR(100) SET @String =’Hi SQL SERVER is fromContinue reading “How to find first and last occurrence of any char or word in sql query?”
How to delete SQL Server Instance ?
How to delete SQL Server Instance ? To uninstall an instance of SQL Server 2008 R2 To begin the uninstall process, from the Start menu, click Control Panel, and then double-click Add or Remove Programs. Select the SQL Server component to uninstall, and then click Change/Remove. This starts the SQL Server Installation Wizard. Setup Support Rules runs to verify your computer configuration. ToContinue reading “How to delete SQL Server Instance ?”
Easy Google Search
How to share easy search link to friend?1. Go to http://lmgtfy.com/ website2. Choose Search engine like “Google, Bing, Yahoo .. etc “3. Enter the search text you want to search4. Click on “Get Link” Button 5. Click on “Preview” Button to view before you share with your friends 6. Copy the URL link and share it with your friends DemoContinue reading “Easy Google Search”
LINQ – Data source Group By Sum
LINQ DataTable table = new DataTable(); table.Columns.Add(“ID”, typeof(int)); table.Columns.Add(“Percentage”, typeof(int)); table.Rows.Add(1, 50); table.Rows.Add(1, 30); table.Rows.Add(2, 0); table.Rows.Add(2, 100); Continue reading “LINQ – Data source Group By Sum”
SQL Server Instance Connection Error
SQL Server Instance Connection Error ERROR A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – The remote computer refusedContinue reading “SQL Server Instance Connection Error”
Arjun's Blog 