Information

  Cast your ntext to nvarchar(max) and do the upper and left operations. Sample below. SELECT UPPER ( LEFT ( cast (Comments as nvarchar(max)), 1 )) + LOWER ( SUBSTRING ( cast (Comments as nvarchar(max)), 2 , LEN( cast (Comments as nvarchar(max))))) FROM dbo.Template_Survey; Following should work for update. Update dbo.Template_Survey SET Comments = UPPER ( LEFT ( cast (Comments as nvarchar(max)), 1 )) + LOWER ( SUBSTRING ( cast (Comments as nvarchar(max)), 2 , LEN( cast (Comments as nvarchar(max)))));

Bounce rate Bounce rate represents the percentage of visitors who enter the site and then leave ("bounce") rather than continuing to view other pages within the same site Bounce rate (%) = Visits that access only a single page (#) ÷ Total visits (#) to the website Example If user visits single page then bounce rate will be Bounce rate = 1/1*100 = 100% If user visits two page then bounce rate will be Bounce rate = 1/2*100 = 50% What Is Adsense Click-Through Rate (CTR)? Google Adsense Click-through Rate (CTR) represents the number of clicks on your ads against the number of times they’ve been shown o your site visitors. For example,   If your ads get 5 clicks out of 100 views (impressions) your Adsense CTR would be 5%. Here’s the simple formula Google uses to calculate Adsense CTR Total Number of Ad Clicks ÷ Total Number of Impressions = Click-Through Rate (CTR) CTR = No. of clicks / No. of exposures CTR% = No. of clicks * 100 / No. of exposures What does D...

ServiceWorker: The script has an unsupported MIME type (chrome-extension)   The Error is showing because of the incorrect path and service worker is not accessible. Path defined for js is not correct, might be you have taken relative path and this is vary on different pages. Replacing: 'service-worker.js' with: '/service-worker.js' OR './ service-worker.js' in ( navigator.serviceWorker.register('/service-worker.js') The service worker file is not present at http://domain.com/service-worker.js so the server is returning index.html instead. Then the registration function has no idea of what to do with a index.html file and tells you that the MIME-type is not correct.  A quick fix would be to copy the service-worker.js file to the public folder so that when you hit http://domain.com/service-worker.js you see the file in the browser.  Remember to go to ChromeDev > Applications > ServiceWorkers and hit Unsubscribe. in order to remove the errored...

  Install Google Analytics to WordPress Without a Plugin In order for Google Analytics to start tracking your visitors, the tracking code mentioned above needs to be present on every page of your site you want to track user behavior on. Usually, that’s all of them. Here’s how you can achieve that manually. Option A: Insert the Code Into  header.php One of the main ways to add the tracking code to your site is to insert it into your header. This way, it will load on every page. Most standard themes have a header.php file that is responsible for outputting the site header section. So, you can simply input the Google Analytics code here. However, when you make changes to theme files, be aware that it’s always best to do it in a child theme. Otherwise, they will get lost when you update your main theme. Child themes are super useful in general and you should definitely read up about them. Also, don’t forget to back up your WordPress site when making any changes like this. Once you...

 window.location.href not working If we are calling function through a submit button. This may be the reason why the browser does not redirect. It will run the code in the function and then submit the page instead of redirect.  In this case Either 1. change the type tag of your button to button           2. you just need to add "return false;" at the bottom of your function