Post
Ask Question
Related resources for Function
  • User-Defined Functions in SQL Server11/21/2024 5:14:12 AM. SQL Server supports two types of User-Defined Functions (UDFs): Table-Valued and Scalar-Valued. Table-valued functions return a table based on logic, while Scalar-Valued functions return a single valu
  • Setting Default Dates in Power Apps: Using Today(), Date(), Year(), and DateAdd() 11/14/2024 6:39:41 AM. Learn how to set default dates in Power Apps using functions like Today(), Date(), Year(), and DateAdd(). This guide explains how to simplify date fields, enhance user experience, and improve app func
  • Explaining Deep Linking in Power Apps 11/12/2024 10:49:37 AM. Deep linking in Power Apps enables direct navigation to specific screens, improving user experience and engagement. By using URL parameters, custom schemes, and StartScreen functions, developers can c
  • Explaning AWS Lambda Function11/12/2024 7:11:04 AM. AWS Lambda is a service that computes the code without any server. It doesn't need any server running, so It is said to be serverless computer. The code is executed based on the response of events
  • Build an Azure Blob Trigger Function to Compress Images with Sharp11/12/2024 5:17:35 AM. This guide walks through creating an Azure Blob Trigger Function that compresses images uploaded to Azure Storage using the Sharp image processing library. It covers setting up Azure Blob Storage, co
  • How to Sort a List of Objects in TypeScript by Property11/9/2024 10:11:36 AM. This guide covers sorting lists of objects in TypeScript, with examples for sorting by string, numeric, and date properties. It demonstrates using the sort() method, localeCompare for strings, custom
  • Library Component Type in SharePoint Framework (SPFx)11/9/2024 7:06:52 AM. SPFx Library Components enable the creation of reusable, modular code in SharePoint. By centralizing utility functions, services, and UI elements, developers can enhance maintainability and consistenc
  • Exploring the New T-SQL Enhancements in SQL Server 202211/5/2024 5:39:41 AM. In this article we will explore the powerful new T-SQL enhancements in SQL Server 2022, including features like DATE_BUCKET, DATETRUNC, and IS DISTINCT FROM, designed to simplify data handling and opt
  • BIT Functions New T-SQL Enhancements in SQL Server10/30/2024 5:58:33 AM. In this article, we’ll explore some of BIT functions new enhancements in SQL Server 2022, their practical applications, and a modified example to demonstrate their usage.
  • Map, Filter and Reduce in TypeScript with Examples10/30/2024 5:47:41 AM. This guide provides a comprehensive overview of these essential functions, complete with practical examples to illustrate their use in real-world applications. Enhance your coding skills and streamlin
  • Windowing Enhancements New T-SQL Enhancement in SQL Server10/29/2024 6:29:27 AM. SQL Server 2022 introduces advanced T-SQL features, enhancing window functions, aggregations, and NULL handling. New options like the WINDOW clause and IGNORE NULLS optimize complex data queries, redu
  • Automate SharePoint Site Creation with Azure Functions and AD Auth10/28/2024 8:53:35 AM. This guide demonstrates how to automate SharePoint site creation using Azure Function Apps with custom Azure Active Directory (AD) authentication. It covers prerequisites, creating an Azure Function A
  • How Select and SelectMany Works in C#10/26/2024 5:05:45 AM. Learn key differences, practical use cases, and examples that demonstrate how these methods simplify data manipulation, making it easier to work with nested and complex data structures in C#.
  • TRIM Function New T-SQL Enhancements in SQL Server10/25/2024 10:44:09 AM. The enhanced TRIM function in SQL Server 2022 adds flexibility for removing unwanted characters in strings, beyond just spaces. Now, developers can use BOTH, LEADING, and TRAILING keywords to trim fro
  • GENERATE_SERIES Function New T-SQL Enhancements in SQL Server10/25/2024 6:06:40 AM. The GENERATE_SERIES function in SQL Server 2022 creates sequences of numbers or dates between specified start and end values, with an optional step. It's beneficial for reporting, filling data gap
  • Understanding the Role of Servers in Modern Networking10/25/2024 4:56:40 AM. Servers play a crucial role in modern networking by managing data storage, processing, and communications across networks. From web hosting and cloud computing to secure data transfer, servers enable
  • TypeScript for advanced type inference in React10/24/2024 4:43:27 AM. In this article, Ziggy Rafiq discusses advanced type inference techniques in React with TypeScript, focusing on hooks and JSX elements.
  • Compiling Multiple Files to Build an Application10/22/2024 10:46:04 AM. This article explains how to compile multiple C files into a single executable using the C compiler. It covers two approaches: compiling multiple files with the cc command or using the #include direct
  • DATETRUNC New T-SQL Enhancements in SQL Server10/9/2024 6:48:59 AM. This new feature simplifies date truncation by allowing developers to truncate dates to specific intervals, such as year, month, or day. It improves query performance and data manipulation in SQL.
  • Exploring Aggregate Functions in Azure Cosmos DB10/7/2024 4:43:48 AM. Aggregate functions in Cosmos DB allow efficient data summarization and analysis across multiple documents. They perform calculations such as AVG, COUNT, SUM, MAX, and MIN to retrieve meaningful insig
  • DATE_BUCKET Function New T-SQL Enhancements in SQL Server10/5/2024 6:28:43 AM. This article will delve into the DATE_BUCKET function, its syntax, and its practical use cases using the AdventureWorks2022 sample database. We’ll also compare DATE_BUCKET with other similar T-SQL fun
  • NTile Function in SQL Server10/3/2024 11:44:37 AM. The NTile function in SQL Server divides a result set into a specified number of groups, assigning ranks to records within each group. Unlike Dense_Rank, NTile focuses on groups rather than individual
  • Understanding Service, Factory, And Provider10/3/2024 11:38:34 AM. AngularJS provides three methods for creating reusable utilities: Service, Factory, and Provider. All serve the same purpose but differ in implementation. Services are singletons, Factories return new
  • How To Create An HTTP Trigger Azure Function App Using Visual Studio 201710/1/2024 8:24:46 AM. Azure Functions is a serverless cloud solution that allows you to run code on-demand without managing infrastructure. It supports multiple programming languages, offers a pay-per-use pricing model, an
  • What is the Filter Function in Power Apps9/30/2024 11:14:40 AM. The Filter function in Power Apps allows users to narrow down data sets by applying specific criteria. It is essential for creating dynamic applications that require user input to display relevant inf
  • What is the Collect Function in Power Apps?9/30/2024 8:32:00 AM. Power Apps enables users to create custom applications with minimal coding, utilizing features like the Collect function for data management. This function allows dynamic storage of various data types
  • Rank and Dense_Rank Function in SQL Server9/30/2024 4:48:24 AM. RANK and DENSE_RANK functions in SQL Server assign sequential numbers to rows based on ordering. RANK skips numbers for ties, while DENSE_RANK does not. Both can partition results using the PARTITION
  • User Record Management in C9/29/2024 5:22:32 AM. This content focuses on implementing functions in C programming to efficiently add and display user records. It covers the creation of structures for storing user details, such as name, age, and conta
  • How to Download Code from Your Azure Function App9/27/2024 5:59:14 AM. In this article, we will learn how to easily download code from your Azure Function App using built-in tools like the Azure Portal, App Service Editor, or source control integration.
  • Getting Dynamic Input Value and Post to the AJAX function9/27/2024 3:20:29 AM. This article explores how to dynamically retrieve input values from a user interface and send them to an AJAX function for processing. It covers essential concepts like event handling and asynchronous
  • Solid Introduction to Expression Trees in C#9/26/2024 4:50:55 AM. This article provides a comprehensive introduction to Expression Trees in C#. You'll learn about their structure, how they represent code as data, and their applications in LINQ queries.
  • Implement Insert, Update and Delete Functionality in the WebGrid: Part 19/24/2024 11:54:26 AM. In this tutorial, we introduce how to implement essential CRUD (Create, Read, Update, Delete) functionality in a WebGrid. This is Part 1 of a series, focusing on adding new records, updating existing
  • What is the Notify Function in Power Apps?9/23/2024 5:09:43 AM. The Notify function in Power Apps displays messages to users, providing instant feedback on their actions. It supports various notification types, such as success, error, warning, and information, hel
  • A Comprehensive Guide to Migrating Azure Functions C# to C# 12 with .NET 8 Isolated9/21/2024 4:12:20 AM. Ziggy Rafiq shows how to leverage modern C# features, and how to optimize the performance and scalability of Azure Functions by migrating them to .NET 8 Isolated Processes.
  • Learn Higher Order Functions in JavaScript9/18/2024 4:33:53 AM. A higher-order function in JavaScript is a function that takes another function as an argument, returns a function, or both. This allows for reusability, code abstraction, and functional programming.
  • How to create a language translator using Google's API and JavaScript9/17/2024 10:42:21 AM. This article demonstrates how to create a language translator using the Google API and JavaScript. It covers integrating the Google API for translating text, contrasting it with previous methods like
  • Dealing With Excel Sheets9/17/2024 10:25:24 AM. Learn essential techniques for managing Excel sheets effectively! This guide covers everything from basic data entry and spreadsheet formulas to advanced features like automation and troubleshooting.
  • Build a Smart Private Chatbot with Semantic Kernel and APIs9/12/2024 4:23:50 AM. This guide covers integrating advanced NLP techniques and machine learning to create a secure, efficient, and customizable AI chatbot with robust data privacy.
  • Creating Azure Functions For SharePoint Operations Using Managed CSOM9/10/2024 11:53:12 AM. This article explains how to create Azure Function Apps to perform SharePoint operations using Managed CSOM code. It covers setting up an HTTP-triggered function, uploading required assembly files via
  • Centralizing String Utility Functions in Java9/10/2024 6:26:13 AM. This article explains how to consolidate common string utility functions in Java by creating a utility class like StringUtils. It covers methods for checking if a string contains only alphanumeric cha
  • Learn Factory Functions in JavaScript9/10/2024 4:25:39 AM. In this article, we will learn about Factory Functions in JavaScript. This article introduces factory functions in JavaScript, demonstrating how they create objects efficiently without code duplicatio
  • Working With Azure Functions From SharePoint Components9/9/2024 11:48:43 AM. This article explains how to trigger Azure functions from SharePoint pages using HTTP trigger functions. It covers creating a SharePoint list from an Azure function using C# and SharePoint CSOM, passi
  • SQL: Not Using Aggregate Function in WHERE Clause, instead, Using HAVING Clause9/5/2024 12:51:37 PM. This article will discuss the issue that SQL: Not Using Aggregate Function in WHERE Clause, instead, Using HAVING Clause
  • Atan2 Function From Power Fx Using Power Apps9/3/2024 6:26:24 AM. Reading this article, you can learn how to perform Atan2 function from Power Fx using in Microsoft Power Apps. Also, you will be able to learn Button control, Label control and TextInput control in th
  • Harnessing the Power of Function Calling with Local LLMs using Ollama8/25/2024 11:45:29 AM. Function calling with Local LLM (Ollama) using C# Semantic Kernel.
  • Type Of Functions In Javascript8/21/2024 10:46:06 AM. This content explores various types of functions, including function declarations, expressions, arrow functions, and callbacks, offering insights into their usage, syntax, and differences in JavaScrip
  • CountDown Timer in JavaScript8/21/2024 6:07:01 AM. This article demonstrates how to implement a countdown timer using JavaScript's setTimeout method. It explains how to create a countdown function that updates the display every second, integrating
  • Describing Musical Domain with F#8/20/2024 7:47:25 AM. It covers domain-specific language (DSL) creation, music representation, algorithmic composition, and sound synthesis, showcasing how F# can facilitate advanced music analysis and generation.
  • Image Scaling by Slider Using HTML58/16/2024 5:02:08 AM. Learn how to scale images dynamically with an HTML5 slider in this tutorial. Using the drawImage method on a canvas element, we adjust image size based on slider input. The article covers HTML setup,
  • Func, Action And Local Function In C# 78/9/2024 12:03:08 PM. This article covers using Func, Action, and local functions in C# 7. It explains how Func returns a value, Action does not, and how local functions can be defined within other methods. Examples includ
  • How to Call JavaScript Function in Angular 18 Component?8/8/2024 9:38:18 AM. Learn how to integrate JavaScript functions within an Angular 18 component. This guide covers how to call and use JavaScript functions effectively in your Angular components, ensuring seamless interac
  • Understanding the NTILE Window Function in SQL8/7/2024 4:10:20 AM. Understanding the NTILE Window Function in SQL" delves into the NTILE function, a powerful SQL tool used to divide result sets into a specified number of roughly equal groups.
  • Understanding ROW_NUMBER() in SQL Window Functions8/2/2024 4:46:39 AM. ROW_NUMBER() is a window function in SQL that assigns a unique number to each row within a partition of a result set. It’s useful for ranking, removing duplicates, pagination, and selecting the top N
  • Count(*) vs Count(1) in SQL8/1/2024 4:11:33 AM. When counting rows in SQL databases, both `COUNT(*)` and `COUNT(1)` are used, but there is no performance difference between them. Modern databases optimize both functions similarly. Prioritize code r
  • @@ROWCOUNT in SQL Server7/29/2024 9:28:40 AM. @@ROWCOUNT is a SQL Server function used to retrieve the number of rows affected by the last executed statement. It provides valuable insights for data manipulation and validation processes, helping t
  • Blazor Web Assembly 3.2 Add/Edit/Delete Fully Functional Application - Part One7/29/2024 8:37:43 AM. This article guides you through creating a Blazor web assembly app with .NET Core hosting. It covers setting up .NET Core APIs, Entity Framework Core for SQL Server data access, and implementing CRUD
  • Functionality of DMA in C Programming7/28/2024 1:08:57 PM. Direct Memory Access (DMA) in C programming is a powerful technique for efficient memory management and data transfer. It allows peripherals to directly access memory without CPU intervention, enhanci
  • JavaScript Functions to Simplify Your Code7/26/2024 5:02:58 AM. Discover how to streamline your JavaScript code with our comprehensive tutorial on essential functions. Learn best practices, coding tips, and techniques to simplify your programming. Perfect for begi
  • SQL Essentials: GROUP BY vs. PARTITION BY Explained7/26/2024 4:08:59 AM. Discover how GROUP BY aggregates data into summary rows, while PARTITION BY divides data into partitions for window functions. Master these techniques to enhance your SQL querying skills.
  • Tracking Visits and Visitor Details on PowerApps Page7/25/2024 12:07:39 PM. Learn to track unique page views in PowerApps by integrating SharePoint lists and using global variables. This guide covers designing lists, configuring PowerApps screens, and patching view counts. It
  • Understanding flatMap in Java7/23/2024 7:42:33 AM. The flatMap operation in Java is a powerful tool for transforming and flattening collections. Learn about Java's `flatMap` operation in this article, which maps each element to a stream and flatte
  • Detailed Explanation of Procedure and Function in SQL Server7/22/2024 6:22:57 AM. Stored procedures are precompiled sets of one or more SQL statements that can be executed together. Functions in SQL Server are essential database objects that contain a series of SQL statements and p
  • Practical approach to EF Core with Scalar functions7/21/2024 6:32:25 PM. Learn how to implement and migrate scalar SQL functions in an ASP.NET Core application using Entity Framework Core. This guide covers creating a scalar function to calculate total unit prices, integra
  • Understand jQuery Ajax Function: Call Web Service Using jQuery Ajax Method7/18/2024 3:19:09 PM. Learn how to use the jQuery Ajax function to call web services and code-behind C# methods. This guide is perfect for novice developers. It covers creating a simple web service, setting up jQuery Ajax
  • Understand jQuery Ajax Function: Read XML Data Using jQuery Ajax Function7/18/2024 3:18:31 PM. This guide delves into using the jQuery Ajax function to read and parse XML data efficiently. It covers the basics of jQuery and Ajax, demonstrating how to make asynchronous requests to fetch XML file
  • How to Call C# Method/Function Using jQuery Ajax7/18/2024 3:18:09 PM. Learn how to call a C# method or function using jQuery Ajax in this step-by-step guide. We'll cover setting up your ASP.NET backend, writing the C# code, and creating the jQuery Ajax call to inter
  • Save as draft and Submit with required, optional functionality and by default required functionality in PowerApps7/18/2024 10:24:46 AM. This is most required feature in any app. If the form is lengthier, it is very useful feature. Any user can fill in the half of the forms and save the form as draft. Later can come in and pickup the f
  • Interactive Rating Control in PowerApps7/17/2024 2:23:06 AM. Explore the integration of rating controls in social media and user-interactive applications using SharePoint lists. Learn about setting display modes, default properties, and user validations to enha
  • Error handling in Transact-SQL (T-SQL) 7/13/2024 10:59:58 AM. Effective error handling in T-SQL (Transact-SQL) is vital for managing unexpected issues in database operations. Using TRY-CATCH blocks, RAISEERROR, and error functions like ERROR_MESSAGE and ERROR_NU
  • How to Convert varbinary to Base64 String in SQL Server7/12/2024 8:47:14 AM. Learn how to convert varbinary data to Base64 strings in SQL Server using XML functions and the CAST method. This tutorial provides clear steps and SQL examples for encoding binary data, crucial for w
  • Lambda Functions and High Order Functions in Android kotlin7/11/2024 4:59:01 PM. The provided Kotlin examples demonstrate basic and high-order functions. In lambda. kt, a lambda function adds two integers. In HighOrder.kt, a high-order function accepts another function as a parame
  • JavaScript - Closures Demystified7/10/2024 12:38:31 PM. Function closures in JavaScript encapsulate variables from their defining scope, allowing functions to retain access to these variables even when executed outside that scope. This tutorial explores cl
  • ACot function from Power Fx using Power Apps7/10/2024 9:23:53 AM. Build custom business apps swiftly with Power Apps, leveraging Power Fx for low-code development across Microsoft Power Platform. Learn to implement the ACot function and utilize Button, Label, and Te
  • Cot function from Power Fx using Power Apps7/10/2024 4:28:42 AM. Reading this article, you can learn how to perform Cot function from Power Fx using in Microsoft Power Apps. Also, you will be able to learn Button control, Label control and TextInput control in the
  • Azure Functions Hosting Models: In-Process and Isolated Models7/8/2024 8:37:11 AM. Explore Azure Functions' hosting models: In-Process offers low latency and simplicity with shared process hosting, while Isolated ensures enhanced isolation and custom dependencies with each funct
  • Essential Components of Prompt Design in GPT's Search7/8/2024 4:49:51 AM. Explore the crucial elements of prompt design within GPT's search capabilities through a comprehensive analysis. Delve into the intricacies of optimizing natural language prompts for enhancing use
  • Understanding @wraps in Python: Preserving Function Metadata7/7/2024 6:28:30 PM. Explore the intricacies of Python's @wraps decorator, essential for preserving function metadata. Learn how @wraps simplifies debugging, maintains docstrings, and ensures correct function signatur
  • Ranking Functions in SQL: RANK, DENSE_RANK, and ROW_NUMBER7/3/2024 12:19:25 PM. Learn how these powerful functions operate within SQL queries to assign ranking values based on specified criteria, enhancing your ability to analyze and manipulate data efficiently in relational data
  • What are Custom Hooks in ReactJS7/3/2024 9:19:26 AM. Custom Hooks in ReactJS empower developers to extract reusable logic from components into standalone functions, enhancing code organization and reusability. They encapsulate stateful logic, side effec
  • PDF Viewer Search functionality in Telerik UI for .NET MAUI7/3/2024 9:07:41 AM. Enhance your mobile and desktop applications with robust search functionality using the PDF Viewer in Telerik UI for .NET MAUI. Easily integrate and navigate through PDF documents with advanced search
  • Connect to Dynamics CRM with Dataverse from Azure Function7/3/2024 4:46:56 AM. Connect seamlessly to Dynamics CRM using Azure Functions with Dataverse integration. Learn how to leverage serverless computing to automate data processes and enhance business workflows.
  • Understanding the PowerApps GroupBy Function7/2/2024 7:03:28 AM. Learn about PowerApps' GroupBy function syntax and limitations. It's effective for grouping text, number, date, and duration columns but doesn't support Choices and Lookup columns. Essenti
  • Learn Use of Lambda Operator in C#7/1/2024 6:28:21 AM. Explore the versatility of lambda expressions in C#, powerful tools for creating inline functions without the need for traditional method declarations. Discover their syntax, applications in LINQ quer
  • The Functioning of Array of Integer Pointers6/30/2024 3:19:12 PM. In C programming, an array of integer pointers is declared similarly to a regular integer array, with the primary distinction being the addition of an asterisk (*) before the array name.
  • Understanding React Hook at a Glance6/28/2024 6:36:47 AM. React Hook at a Glance" provides a concise overview of React Hooks, the revolutionary feature introduced in React 16.8 that allows developers to use state and other React features in functional c
  • IIF in Microsoft SQL Server6/28/2024 6:29:20 AM. IIF function in SQL, also known as "Immediate If," provides a concise way to perform conditional evaluations within queries. It allows SQL developers to return different values based on whet
  • The Implementation of Pointer to Function6/27/2024 11:58:19 AM. This content explores the implementation of pointers to functions in C and C++ programming. It delves into their syntax, usage, and benefits, such as dynamic function calls, callback functions, and ef
  • Find and Replace in PowerApps6/27/2024 10:52:39 AM. Learn to streamline data entry and enhance user experience by implementing powerful text manipulation techniques within your canvas apps, leveraging Microsoft's Power Platform capabilities seamle
  • App Settings in App Service Vs App Configuration Resource in Azure6/24/2024 9:19:22 AM. Learn the distinctions between Azure App Settings and Azure App Configuration for effective application configuration management in Azure. Azure App Settings are tailored for individual FunctionApps/A
  • API vs Service vs Function Connections in Azure Logic Apps6/24/2024 9:08:23 AM. Azure Logic Apps helps automate tasks, business processes, and workflows by connecting to various services. API Connections integrate with third-party and Azure APIs, Service Provider Connections dire
  • Adding Facebook Share Functionality To An ASP.NET Website With A Master Page6/24/2024 9:02:49 AM. Learn how to add Facebook share functionality to your ASP.NET website with a master page. This guide provides step-by-step instructions to integrate the Facebook Share button, enabling seamless social
  • Integrating Azure SQL Database with Azure Functions - Azure Essentials Series - Ep: 46/24/2024 8:23:23 AM. In this episode, you'll learn how these two services can work together to build scalable, serverless applications that efficiently manage and process data.
  • Predicate Delegates in .NET Core C#: Syntax, Usage and Examples6/22/2024 10:26:47 AM. Like Func and Action delegates, the predicate is a delegate. It symbolizes a procedure that verifies that the passed parameter satisfies a set of requirements. One input parameter must be provided by
  • Implementing Webhooks with Next.js6/21/2024 6:42:03 AM. In this article we will learn about implementing webhooks in Next.js empowers our application with real-time capabilities, allowing seamless integration with external services and automating business
  • Transforming Data in JavaScript: Exploring Map, Filter, & Reduce6/21/2024 6:31:18 AM. In JavaScript programming, mastering array methods like map, filter, and reduce is essential for efficient data manipulation. Map transforms arrays by applying a function to each element, filter selec
  • Introduction To Azure Function App6/20/2024 10:10:26 AM. Discover the power of Azure Function Apps, Microsoft's serverless computing service. Learn to leverage event-driven architecture for scalable, cost-efficient solutions in the cloud.
  • Local And Global Variables In Power Apps6/20/2024 6:44:06 AM. Local variables are temporary and screen-specific, declared using the UpdateContext function (e.g., UpdateContext({LocalVariableName: Value})). Global variables, declared with the Set function (e.g.,
  • Unlock Small Language Models Deep Dive Parameters Loss Optimization RAG6/17/2024 10:42:17 AM. Language models have revolutionized the field of natural language processing (NLP), enabling machines to understand, generate, and respond to human language with remarkable accuracy. At the heart of t
  • Java Script Callbacks: Syntax, Usage, and Examples6/17/2024 10:02:11 AM. JavaScript is designed to support asynchronous programming; it can handle numerous tasks concurrently. JavaScript callbacks are crucial because they let you run code after an asynchronous task complet
  • Integrating Azure SQL Database with Azure Functions6/17/2024 9:26:04 AM. Azure SQL Server is a fully managed database service by Microsoft Azure, offering scalability, high availability, and robust security features. It integrates seamlessly with Azure Functions for buildi