Resources No resource found - Understanding Guard Clauses in C#Jan 01, 2024. Guard clauses are an essential aspect of writing clean, readable, and robust code in C#. They serve as initial validation checkpoints at the beginning of a method, ensuring that the method is executed only when the incoming parameters meet certain criteria. Guard clauses help in the early detection of invalid inputs or conditions, preventing further execution of the method and reducing the chances of unexpected errors.
- Guard Clauses in C#Dec 12, 2023. What are guard clauses? How do they implement them in . NET? There are multiple ways of implementation. How are they different from validation?
- How To Work with JSON in SQL Server?Aug 08, 2023. In this article, we will learn about How To Work with JSON in SQL Server
- Early Return Pattern in C#Jul 28, 2023. We will have an overview of the early return pattern and some examples in C#
- How To Use LIMIT in MySQL?Jun 20, 2023. The LIMIT clause is used to limit the number of rows returned by a SELECT statement in MySQL. It is typically used in combination with the ORDER BY clause to specify the order in which the rows should be returned. The syntax for the LIMIT clause is as follows.
- How to use IN Operator in MySQLMay 10, 2023. use IN operator in MySQL
- SQL Where StatementMay 10, 2023. In this article we will discuss about SQL Where statement
- Elasticsearch Boolean QueriesJan 12, 2023. In this article, we will see how to write Boolean queries and how it is working in Elasticsearch.
- How To Add Custom Add-Ins To MS WordOct 07, 2022. This article shows you how to add add-ins to word desktop.
- How To Add Add-Ins In PowerPoint Sep 20, 2022. In this article, you will learn how to add custom add-ins.
- How To Deploy Excel Add-ins To Your OrganizationAug 12, 2022. This article show you how to deploy excel add-ins in your organization.
- How To Add Custom Add-Ins To ExcelJul 05, 2022. In this article, you will learn how to add Excel add-ins.
- How To Deploy PowerPoint Add-ins To Your OrganizationJun 15, 2022. This article shows you, how to deploy PowerPoint add-ins.
- How To Deploy Word Add-Ins To Your OrganizationJun 03, 2022. This article show you how to deploy word add-ins to your organization.
- How To Create Excel Add-InsMay 10, 2022. in this article i will show you how to create Excel Add-ins
- Using For XML Clause In SQL QueriesMay 05, 2022. For XML clause is used to convert the SQL result set into XML format. It is a very much helpful clause when we need XML data from the SQL result set. The FOR XML clause can be used in top-level queries and in subqueries. The top-level FOR XML clause can be used only in the SELECT statement. In sub queries, FOR XML can be used in the INSERT, UPDATE, and DELETE statements. 
- How To Create PowerPoint Add-InsApr 04, 2022. in this article, I will show you how to create PowerPoint Add-ins
- Quick Tip - Remove CONVERTS/CASTS From WHERE/JOIN ClausesMar 29, 2022. In this article, you will learn how to remove CONVERTS/CASTS from WHERE/JOIN clauses.
- How To Deploy Outlook Add-ins To Your OrganizationMar 19, 2022. This article provides a comprehensive guide on deploying Outlook add-ins to organizations for other users. It covers the step-by-step process of deploying add-ins using Office 365, ensuring easy access for users within the organization.
- How To Publish Outlook Add-Ins Using Visual Studio CodeMar 17, 2022. In this article, you will learn how to publish outlook add-ins using visual studio code.
- How To Create Word Add-InsMar 16, 2022. in this article I will show you how to create word add-ins.
- How To Create Outlook Add-insNov 24, 2021. In this article, you will learn how to create outlook Add-ins.
- Difference Between HAVING And WHERE Clause In SQL ServerSep 06, 2021. This tutorial will show you the difference between the HAVING and WHERE Clause in SQL Server.
- SQL - Order By ClauseJun 15, 2021. In this article, you will learn about SQL "Order By" Clause.
- Create Dynamic Pivot Table Using Store ProcedureJan 18, 2021. In this article I will tell you how we can create dynamic pivot table using pivot clause and store procedure. In this article we will create a store procedure which takes some parameter and generate pivot table.
- Overview Of Yeoman Generator For Office Add-insDec 08, 2020. In this article, you will learn about the Overview of Yeoman Generator for Office Add-ins.
- Develop Outlook Add-ins with SharePoint FrameworkFeb 25, 2020. In this article, you will learn how to develop Outlook Add-ins with SharePoint Framework.
- Create And Deploy Outlook Add-Ins Using SPFx 1.10Feb 04, 2020. Create And Deploy Outlook Add-Ins Using SPFx 1.10" is a guide for integrating custom functionalities into Microsoft Outlook using SharePoint Framework (SPFx) version 1.10. It offers insights into developing, deploying, and managing Outlook add-ins within the Microsoft 365 ecosystem.
- Zero To Hero In MS SQL Server - Part SixSep 17, 2018. In this article, I have shared some knowledge on WHERE CLAUSE and Update SQL Statement.
- Install add-ins In SharePoint Using Office 365 CLIJun 14, 2018. I describe how to move SharePoint add-ins to app catalog and install using Office 365 CLI
- How To Register/ Unregister SharePoint Add-Ins Using PowerShellJun 04, 2018. Suppose you would like to have the remote components of a provider-hosted SharePoint Add-in to interact with SharePoint, what should you do? You should first register with the Azure ACS cloud-based service and the SharePoint App Management Service of the tenancy or farm. Let us now dive straight into how to register/unregister SharePoint add-ins.
- Automating SVN Check-Ins And Building A Project Via JenkinsFeb 05, 2018. In this article, we learn to automate SVN Check-Ins and building a project via Jenkins.
- Comparison Of Subquery And JoinsJan 15, 2018. Here, in this article, we are comparing the SQL Join and SQL Subquery.
- How To Use Joins, and Group By Clause In Entity Framework With LINQ C#Jul 15, 2017. In this article will be going to learn How to use Joins, and Group By Clause in Entity Framework with Linq C#
- Getting Started With O365 - SharePoint-Hosted Add-Ins Using JSOMFeb 28, 2017. In this article, you will learn about SharePoint-hosted add-ins, using JSOM.
- Creating SharePoint Hosted Add-ins In SharePoint Server 2016Sep 25, 2016. In this article, you will learn how to create SharePoint Hosted Add-ins in SharePoint Server 2016.
- Configure Environment For Add-Ins In SharePoint 2016Sep 16, 2016. In this article, you will learn how to configure environment for add-ins in SharePoint 2016.
- SharePoint Add-ins (SharePoint Hosted Add-in) - Part TwoMay 28, 2016. In this multi part series, this is part two. In this article I’ll try to cover SharePoint hosted add-in with example.
- Upgrade SharePoint Hosted Add-Ins(Apps) in SharePoint 2013May 22, 2016. In this article you will learn how to Upgrade SharePoint Hosted Add-Ins(Apps) in SharePoint 2013.
- SharePoint Add-ins (SharePoint App) - Part OneMay 16, 2016. In these multi part series, I’ll try to cover all the details related to SharePoint Add-ins (SharePoint App). In this article I’ll start with the introduction/basics of SharePoint Add-ins.
- SQL Server: Use CASE in WHERE ClauseApr 07, 2016. In this article I am going to show how we can use CASE in WHERE clause.
- SQL For Beginners - LIKE And IN ClauseJan 19, 2016. This article will help you understand the Like and In Clause of SQL.
- SQL For Beginners - WHERE ClauseJan 09, 2016. This article will help you to learn the WHERE clause and expressions used with it.
- Difference Between ROW_NUMBER () OVER () & PARTITION BY ClauseJul 29, 2015. In this article you will learn the difference between ROW_NUMBER(), OVER() and PARTITION BY clauses in SQL Server.
- Output Clause in SQL ServerJul 10, 2015. In this article we will learn about output clauses in SQL Server.
- OFFSET-FETCH Clause in SQL ServerApr 06, 2015. This article explains the OFFSET-FETCH clause that is a filltering option, like top, that can filter the data based on the number of rows.
- Basic Terminology of SQL ServerMar 17, 2015. In this article we learn SQL from the basics. Here I describe all the basic terminology of SQL.
- How to Show Group Rows Using Group By in SQL ServerFeb 18, 2015. In this article we will see how to group rows using Group By and we will also see the difference between the Where and Having clauses.
- OUTPUT Clause in SQL ServerNov 15, 2014. This article explains the OUTPUT keyword including the basic advantages of it.
- Over Clause in SQL Server (Windows on Data) Part 2Aug 28, 2014. This article explains the over clause in SQL Server.
- Over Clause in Sql ServerAug 17, 2014. SQL Over. This article explains how SQL Over clause works. Windowing in SQL Server is done by the over clause that was introduced in SQL Server 2005.
- Subquery vs Correlated Subquery in SQLJun 29, 2014. In this article I will briefly describe a subquery vs a correlated subquery in SQL.
- Restriction and Projection Operator in LINQJun 23, 2014. In this article we will learn about the Restriction and Projection operators in LINQ, their syntax and their functionality with examples.
- GROUP BY Clause In QlikViewApr 28, 2014. This article prvides the basic concepts of the GROUP BY clause in QlikView applications.
- HAVING Clause In QlikViewApr 28, 2014. This article describes the introduction of a HAVING clause and also introduces how it is used.
- Find The 3rd Or Nth Highest Salary In A Table Via SubQueryFeb 14, 2014. This article describes how to find the 3rd or Nth highest salary in a table. To find the Nth highest salary, we need to create a table in the database containing some data and to do this use the following procedure.
- Working With Having Clause in F#Dec 02, 2013. My previous article explaiined how to use Group by clause using Stored Procedure in Windows Forms application now I will describe in this article the Having Clause and how to use this clause in Windows in a Stored Procedure.
- Oracle SQL Commands: Part 9Nov 12, 2013. In this article you will learn about more Oracle commands.
- Oracle SQL Commands: Part 6Nov 07, 2013. In this article you will learn about various select commands in Oracle.
- Oracle SQL Commands: Part 7Nov 07, 2013. In this article you will learn about various Oracle commands.
- Sub Query in Oracle: Part 2Nov 06, 2013. This article explains the use of Sub Queries. Here we see examples of Multiple Row Sub Query, Multiple Column Sub Query, Nested Sub Query, Correlated Sub Query.
- Sub Query in Oracle: Part 1Nov 06, 2013. In this article, I share the use of a Sub Query. If a Query that contains another Query, then the Query inside the main Query is called a Sub Query and the main Query is known as the parent Query.
- T-SQL Query Performance Tuning TipsAug 09, 2013. In this article, I will discuss some useful T-SQL query performance tips and tricks for SQL server developers.
- Office Application Development in Visual StudioJul 31, 2013. In this article you will learn about the office application development in Visual Studio 2013 Preview.
- How to Create Add-Ins Using VSTO in MS-WordJul 26, 2013. VSTO application add-ins allows developers to extend Office applications. Visual Studio Tools for Office (VSTO) is a set of development tools available in the form of a Visual Studio add-in (project templates).
- Merge Statement With DML Operations in SQL ServerJul 10, 2013. This article defines how to insert, update and delete records in a database table using the merge statement in SQL Server.
- Some Important Tips For SQL Query PerformanceJul 01, 2013. This article provides some important tips for SQL Query Performance.
- Find and Delete Duplicate Records From SQL TableApr 30, 2013. In this article I explain how to count and delete duplicate records from SQL database table.
- Creating Subquery in SQL ServerApr 25, 2013. This article shows how to create a subquery to a select statement in SQL Server.
- MySQL DISTINCT Operator in PHPApr 04, 2013. In this article I will explain MySQL DISTINCT operator in PHP.
- GROUPING SETS Clause in SQL ServerFeb 05, 2013. In this article we explain the GROUPING SETS clause in SQL Server.
- MySQL Where Clause in PHPJan 31, 2013. I will describe in this article how to use the MySQL where clause in PHP.
- Group By Clause in PHPJan 10, 2013. In this article I explain how to use a MySQL group by clause in PHP. The group clause is used to group the rows of a result set based on one or more column expressions. Group by clause determines how the selected rows are grouped. The group by clause follows the where clause.
- Creating Check Constraint on a Table in SQL Server 2012Dec 20, 2012. This article will give you an idea of how to use the SQL Server Check Clause and also defines where you can use it.
- Output Clause With Insert, Delete and Update Statement in SQL Server 2012Dec 18, 2012. This article will give you an idea of how to use the Output clause and also defines where you can use it.
- Select Query Using TOP WITH TIES Clause in SQL Server 2012Dec 18, 2012. In this article, I will explain the use of the TOP WITH TIES Clause in SQL Server.
- On vs Where Clause in SQL Server 2012Nov 27, 2012. Here, I will explain the difference between the On and Where clauses when used with a left join in SQL Server.
- Using Having Clause in SQL Server 2012Nov 19, 2012. In this article, I will try to highlight all the major points related to the Having clause in SQL Server.
- Co-related Queries and Self Join Using LINQNov 17, 2012. Today, in this article let’s play around with one of the interesting and most useful concepts in LINQ.
- Select Query Using Like Clause in SQL Server 2012Oct 19, 2012. In this article, we will see how to use the Select Query Using Like Clause in SQL Server 2012. The percent sign (%), Underscore (_), Bracket ([]), Caret (^) are wildcard characters in SQL Server.
- Select Data From XML With Where Clause Using LINQ to XMLOct 16, 2012. Today, in this article let’s play around with one of the interesting and most useful concepts in LINQ to XML. Select Data From XML With Where Clause Using LINQ to XML.
- A Simple Use of Case Statement in SQL Server 2012Oct 09, 2012. This article will give you an idea of how to use a Case expression in SQL Server.
- Merge Statement in SQL Server 2012Sep 12, 2012. Here, you will see how to perform insert, update, or delete operations on a target table based on the results of a join with a source table using a merge statement.
- Adding Power Pivot Add-Ins in Excel 2013Aug 28, 2012. In this article we will discuss how to add the Power Pivot in Excel 2013.
- How to Use Over Clause With Order By in SQL Server 2012Aug 23, 2012. In this article I am going to explain how to use an over clause with Order By in SQL server 2012.
- Adding Subquery in a Select Statement in SQL Server 2012Aug 17, 2012. Today, I have provided an article showing you how to add a subquery to a select statement in SQL Server 2012.
- Searching Record in Windows Store App Using LINQJul 13, 2012. Today we will create a search query operation in a windows store application with the help of LINQ.
- Having and Alias Clause in MySQLDec 14, 2011. In MySQL, the HAVING and AS (Alias) clauses are powerful features used in conjunction with the SELECT statement to filter and rename data retrieved from a table. Let's look at each clause individually.
- Difference Between On Clause And Where Clause When Used With Left Join in SQL ServerAug 04, 2011. The purpose of this article is to show the difference between the On clause and Where clause when used with a left join in SQL Server.
- Ins Tag in HTML5Aug 02, 2011. The ins tag defines text that has been inserted into a document.
- Output Clause and its UsageDec 28, 2010. Output Clause is introduced in SQL Server 2005 version which is quite useful in various scenarios. It has access to Inserted and Deleted table which is also called the magic tables.
- SQL Optimization Tips Mar 31, 2010. This article lists some of the optimization tips for SQL Server development.
- Introduction to Interfacing Win Forms with VS Add-insMar 04, 2009. Learn to integrate Visual Studio Add-ins with Win Forms for enhanced user interaction. Utilize Form controls, event handling, and DTE to create a seamless interface. Manage windows, buttons, and lists efficiently for a robust development environment.Learn to integrate Visual Studio Add-ins with Win Forms for enhanced user interaction. Utilize Form controls, event handling, and DTE to create a seamless interface. Manage windows, buttons, and lists efficiently for a robust development environmentLearn to integrate Visual Studio Add-ins with Win Forms for enhanced user interaction. Utilize Form controls, event handling, and DTE to create a seamless interface. Manage windows, buttons, and lists efficiently for a robust development environment."
- Introduction to Visual Studio Add-insMar 03, 2009. This article explains about Visual Studio 2008 Add-ins.
- Using OUTPUT Clause for Getting Deleting Information from Several Tables.Apr 01, 2008. In this article I will explain how you can use such a T-SQL (SQL Server 2005) feature as OUTPUT clause in order to get information about rows, which were affected, when deleting process is executed for several tables, “connected” by foreign keys. The examples are written using T-SQL and C#.
- Real Life SQL and .NET: Part IVJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
- Basics of Extending Your Working Environment in Visual StudioApr 10, 2003. All of us have used Macros in Microsoft Office and Add-ins in Visual Studio 6 and I am very sure all of us have been impressed as well by their power to control their own working environment.
- The "ins" and "outs" of Using Stored Procedures in C#Jan 27, 2003. This article reviews the creation of stored procedures with parameters using the Visual Studio IDE.
- Tutorial : Creating Visual Studio Add-InsJul 10, 2002. In this example we'll create an add-in that allows you to insert a copyright statement at the top of your code window.
- .NET Assemblies Ins and Out : Part IIIApr 20, 2001. This is the third part of a series on .Net assemblies, delving into utilities for assembly manipulation. The Assembly Linker (AL.exe) aids in GAC installation, manifest creation, and resource addition, offering options like specifying entry points and adding version information.