Monthly Archives: November 2019

SQL Server UPDATE JOIN

By | November 28, 2019

UPDATE Table1 SET column1 = T2.column1, column2 = T2.column2 FROM #Table1 T2 JOIN #Table2 T2 ON T1.Column3 = T2.Column3 Lets say we have employee & ProjectTeam table as below respectively, Id Name Address PhoneNumber 11 Ajay Mumbai 887 12 Jatin Pune 356 ProjectId EmpId PhoneNumber P123 11   X234 12   So now we want… Read More »

Intersection of two string arrays in c#

By | November 27, 2019

lets say we have two arrays and we want to find common element which are present in both the arrays, then use intersect method. It is an extension method present in system.linq namespace. string[] days1 = {“Mon”,”Tue”, “thr”, “Fri”, “Sun” }; string[] days2 = {“Mon”,”Wed”, “Fri”, “Sat”, “Sun”}; Here we want to find common days… Read More »

anchor tag href value in jquery

By | November 25, 2019

while working on one project, we came across situation, were we want to read href value of anchor tag and url parameters value, <a href=”f10debug.com\details?name=jatin” class=”mainClass”>jatin nahar</a><br/> so we can read the href value anchor tag as below, $(document).ready(function() { $(“a.mainClass”).click(function( var name = $(this).attr(‘href’).split(‘=’); console.log([1]); }); });  

Microsoft GD Interview Questions

By | November 13, 2019

One of my friend attended Microsoft GD Interview recently, i have captured some of the interview questions please find them as below, Protected abstract class Difference between Access modifiers Public Private Protected Internal Protected Internal Assemblies vs. Namespace Assemblies vs. App Domain How App domain works How IIS works Why App Domain If two assemblies… Read More »