Category: Duplicate
-
Replace Blank CELLs with NULL Value
SELECT ‘UPDATE table SET [‘ + name + ‘] = NULL WHERE [‘ + name + ‘] = ””;’ FROM syscolumns WHERE id = object_id(‘table’) AND isnullable = 1;
-
The provided anti-forgery token was meant for user “”, but the current user is “user@example.com”
While working with Asp.net MVC, I got HttpAntiForgeryException exception (The provided anti-forgery token was meant for user “”, but the current user is “user@example.com”) at login page. It happens when user login with valid credentials and re-directed to inner page ofr the application. At inner pages he press the browser back button and will show…
-
remove duplicate values from a excel cell
Microsoft Excel is used by everyone in the world for all data related things, some time we have duplicate cell contents in rows or in columns. To remove these duplicate values from the sheet we already have a feature “Remove Duplicates” in latest version of the excel application. But if we have some duplicate values…