• SQL Server interview question  :- What is use of Coalesce and ISNULL ( SQL Server training)?
    Articles,  Blog

    SQL Server interview question :- What is use of Coalesce and ISNULL ( SQL Server training)?

    In this video will try to understand what exactly is the use of ISNULL function and what is the use of Coalesce function Let me pronounce again coalesce I am not sure that if that pronounciation is right but english is my second language In case it is not right I am extremely sorry for that In this video we will try to demonstrate ISNULL and Coalesce function First start with ISNULL In order to demonstrate the ISNULL function I have created a very simple table here The table name is tblPerson and it has two columns first name and surname and if you go and fire select query over…

  • Articles

    SQL Server interview training :-What are triggers , inserted and deleted tables ?

    In this video will talk about what exactly are triggers, and in what scenario we should be using them While we do that will talk about two important types of tables one is called as inserted table and the other one is called as deleted table Will talk about two different kinds of triggers i.e called as the Instead of trigger and the After trigger Triggers are logic like stored procedures which can be executed before the updation happens on a table or after the updation happens on a table If you want to execute pre processing or post processing logic after the updation or before the updation you can…

  • .NET Conf 2019 Teaser
    Articles,  Blog

    .NET Conf 2019 Teaser

    >>On this episode of ON.NET we’re going to cover all things.NET Conf with.>>Beth Massi. [MUSIC]>>Hey, everyone. Welcome back to another episode of ON.NET. I am not Richard Lander. I’m [inaudible] , and today we’re here with Beth Massi.>>Hey, Gomez, is great to have you interviewing me.>>We want to have the women who actually produce.NET Conf, talking about.NET Conf.>>Exactly. I mean we are behind the scenes of this entire show, right?>>Yeah.>>So we want to get ON.NET here and give you guys a little sneak peek of what we’re planning.>>So let’s start at the beginning, what year are we on right now for.NET Conf How many years have we done this.>>This will…

  • Visual Studio Code Web Dev Setup In 6 Minutes – (2019)
    Articles,  Blog

    Visual Studio Code Web Dev Setup In 6 Minutes – (2019)

    in this video we’ll go over the basic setup and configuration of visual studio code. What’s up YouTube? This video is intended for beginners. I’m assuming you have zero knowledge of code writing. So if you’re just getting started you’re in the right place. Hit that subscribe button and let’s get started. The first step to writing code is picking a code writing application. There’s a ton of them out there like notepad++, sublime text, Atom, and my favorite Visual Studio code, not to be confused with Visual Studio, VS Code is a free open source application. It has great support from the community and tons of extensions. The other…