How to get the number of rows affected in SQL Server (Transact-SQL)?
You can retrieve the no of affected rows using the system variable - ‘@@ROWCOUNT’
Recent posts
IIS - Cannot Start Application Pool
Error: Cannot Start Application Pool. There was an error while performing this operation.
Error: Uncaught (in promise): TypeError: Cannot read property ‘push’ of undefined TypeError: Cannot read property ‘push’ of undefined
Cannot read property ‘push’ of undefined? let fareConfigList: FareConfig[]; Solution: Initialize the array with ‘[]’ let fareConfigList: FareConfig[] = [];
How to clear the immediate window in Visual Studio 2019?
What is the use of an immediate window? It is used to debug and evaluate expressions, execute statements, and print variable values.
How can we locate the anchor element using their text in XPath?
Below code, snippets help you to find the anchor element using its text in XPath and the sample code to use it in the selenium.
npm is not recognized as internal or external command, operable program or batch file
Add the Nodejs path in your environment variables.
Setup a default route in ASP.NET Core 3.1 MVC
ASP.NET Core Creating a new ASP.NET Core Web Application on choosing an empty template will leave you with the empty configuration in the startup class fi...
The type or namespace name ‘Task<>’ could not be found (are you missing a using directive or an assembly reference?)
If you are getting the below error when try to use the Task<>, The type or namespace name ‘Task<>’ could not be found (are you missing a using di...
HTTP 415 unsupported media type error when calling Web API 2 endpoint
You have to send the header to accept the content type.
How to disable Https or SSL in Visual Studio 2019 for web project?
You can disable the SSL or HTTPS in Visual Studio 2019 for your local project execution. Below are the steps,
Adsense: URL must be a valid top-level domain
If you’re getting this error “URL must be a valid top-level domain” in the Adsense account while adding a new site like, http://www.sample.com Screenshot ...
Custom domain not working without WWW in Blogger
The issue fix is pretty straightforward. The problem is with the ‘A record’ which you have added under the DNS Management in the control panel.
How to setup a custom domain on blogger with GoDaddy?
You can purchase a new domain from GoDaddy, BigRock, or any other domain provider and follow the below steps to configure the custom domain in the Blogger pl...
.NET Core 3.1 not showing in visual studio?
Visual studio 2019 professional or community edition is not showing the framework “.NET Core 3.1”?
System.Collections.Generic.IEnumerable does not contain any definition for ToList
You might be getting this error when trying to convert the Enumerable to List using ToList. It means the namespace to import the LINQ has been missed in your...
How to delete all the websites hosted in IIS?
You will end up in the situation to delete one or more website instances hosted in the IIS server. I know it’s a frustrating task to delete the sites one by ...
Angular 9 - Now Available. Features and How to update to Angular version 9?
This release switches you to the new Ivy compiler and run time by default. This is one of the biggest updates to Angular in the past 3 years. It’s recommende...
Angular & Typescript - How to get unique items or remove duplicates from array?
In Typescript, there is no built-in function to retrieve the unique items from Array. The below code is a custom function that uses contains (in typescript i...