SQL QUERY IS NOT NULL AND IS NULL VALUE COMBINATION QUARY - fabulouscode

    • Monday, September 2, 2019

    Home SQL SQL SERVER SQL QUERY IS NOT NULL AND IS NULL VALUE COMBINATION QUARY

    SQL QUERY IS NOT NULL AND IS NULL VALUE COMBINATION QUARY





    SELECT DISTINCT SpecialWorkID, OrderDetailBodyID, SpecialWorkTypeID, TypeStatus, createby
    FROM dbo.tblSpecialWorks
    WHERE (OrderDetailBodyID = 437848) AND isnull(createby , 'Md. Nuruzzaman')='Md. Nuruzzaman'
    Tags
    Author Image

    About Author::
    I am a Software Developer, expert in SEO, ASP.NET, MVC, MSSQL, PHP (OPP), PHP (MVC) with MySQL,Java, Android, I have working experience in rapid software design and development of Microsoft and Oracle based desktop, web, Mobile applications and services including SQL Server and Oracle database design and optimization, API development and devices integration. I have strong background and understanding of OOP and MVC Framework, which make my skills more concrete. Combined with a vast knowledge of technologies such as C#, ASP.Net MVC, WCF/ Web API, Entity Framework, SQL, SSRS, SSIS, Crystal Reports, RDLC, AngularJs, Knockout, Bootstrap, Telerik, Ajax, Javascript, JQuery, HTML5, CSS3 , ASP.net Zero and more, I am able to offer Python time-lines using a balance of innovative solutions and tools.
    Regards,
    Safiqul Islam Tuhin
    Founder Fabulous Code

    By at
    Labels: ,

    No comments:

    Post a Comment

    I am Safiqul Islam Tuhin

    Subscribe to: Post Comments (Atom)