Thursday, 30 March 2017

Facebook getuser returning 0 Active access token required

Facebook getuser returning 0 and An Active access token must be used to query information about the current user If you are getting above error after March 25, 2017 then you  may be using Facebook API version - 2.2. The reason of this error is facebook api version - 2.2...

Sunday, 26 March 2017

How to call a function before leaving page - Jquery beforeonunload

Hi guys, Shraing Code Snippet for Calling a function before leaving page. It may be required for variety of purposes. you can use it to track statistics for user's leaving from a website page to record that page for bounce pages statistics from where user is leaving website mostly. this is just a simple example you can use it for variety of way. you can share in comments for...

Wednesday, 7 December 2016

Difference Between Where and Having Clause

The WHERE clause does not work with aggregates like SUM,Count etc. The SQL above will not work, because the where clause doesn’t work with aggregates – like sum, avg, max, etc.. Instead, what we will need to use is the having clause. The having clause was added to sql just so we could compare aggregates to other values – just how the ‘where’ clause can be used with non-aggregates....

Tuesday, 6 December 2016

How To Redirect Non-www to www in Asp.net

Please Follow Below Set of Steps to Redirect Non-www To www for your domain in asp.net or asp classic Web Application : - 1. Open web.config file of your Web Application 2. Before Closing of </system.webserver> Add below code in order to redirect your domain     from xyz.com to http://www.xyz.com for all pages of your website - <system.webServer>  ...

Difference Between System.Web and System.WebServer

System.web is the settings section for IIS6 and the built in cassini server (the test server in Visual Studio 2010 and before where you are targeting asp.net 3.5 or lower) The system.webserver is a child of the configuration section that means in web.config file <system.webserver> tag is placed under <configuration> Tag. System.WebServer Tag is contained in web.config...

Thursday, 17 November 2016

what are CTE? When and Why To Use CTE in SQL ?

What are CTE in SQL ? CTE are Common Table Expressions first introduced in Sql Server 2005. It is basically a result set or result holder or separate plugin / extension that can hold some complex query separately from main query and supply the named result set or result holder name in place of that complex query in main query. It really improves complexity of complex queries....

Table Valued Functions in Sql

What are Table Valued Functions in Sql ? There are two types of “User Defined” fucntions in sql server scalar function ( that returns single value in response to function call )      2. inline table valued ( that returns function result in tabulated form but query can single lined e.g.      3. return (select * from table_name). 1. Inline...

Wednesday, 16 November 2016

Google Joined .NET Foundation

Its great news by microsoft that google joined .net foundation. Recently Samsung also joined .Net foundation for Tizen platform. Apart from everything its great that all tech companies are working collectively to make good environment for innovation. This Move of Big companies...

SQL Server Public Preview available on Ubuntu

Microsoft has just announced its public preview of the next release of SQL Server, and Canonical is delighted to announce that this preview is available for Ubuntu. Moreover, with SQL Server on Ubuntu, there are significant cost savings, performance improvements, and the...

Tuesday, 8 November 2016

₹500 and ₹100 Notes Banned In India : 25 Points You need to know

NDA Government has implemented smart move as slap to Black Money holders. Money of Black Money Holders will be of no cost if they kept it in their safe lockers. GPS chip based notes will be out in market soon and old notes must need to be deposited in banks as announced by Government of India. Black money holders must need to take their money out in banks otherwise they will...