Post
Ask Question
Related resources for SQL Functions
  • 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
  • @@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
  • 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.
  • SQL Functions and Examples.1/10/2024 6:08:41 AM. This article provides you with many built-in SQL functions including aggregate functions, date functions, string functions, control flow functions, window functions, and math functions.
  • 50 SQL Server Interview Questions Guaranteed to Help You In 2023 7/25/2023 7:16:19 AM. A complete guide of top SQL Server interview questions and answers that will help pass your SQL Server interview.
  • How To Use Aggregate Functions In MySQL4/26/2023 9:33:08 AM. Aggregate functions are functions that perform calculations on groups of rows in a database and return a single result. They are commonly used in SQL to summarize data and calculate statistics. Here a
  • SQL Functions3/9/2023 5:58:33 AM. In this article, you will learn how to learn SQL functions and types of functions.
  • SQL Security Functions: Part 43/3/2023 12:05:58 PM. In this article I describe the Transact-SQL security functions SUSER_ID , SUSER_NAME , SUSER_SID , SUSER_SNAME and SYSTEM_USER.
  • SQL Security Functions: Part 33/3/2023 11:41:12 AM. In this article I describe the Transact-SQL security functions SUSER_ID, SUSER_NAME, SESSION_USER and SESSIONPROPERTY.
  • SQL Security Functions: Part 23/3/2023 11:09:53 AM. In this article, I describe the Transact-SQL security functions IS_MEMBER , IS_SRVROLEMEMBER , LOGINPROPERTY, ORGINAL_LOGIN, and PERMISSION.
  • SQL Security Functions: Part 13/3/2023 7:15:56 AM. In this article, I describe the Transact-SQL security functions CURRENT_USER, HAS_DBACCESS, HAS_PERMS_BY_NAME, and HASHBYTES.
  • Using Right and Left Function in SQL Server1/12/2023 6:21:53 AM. In this article I provide a quick overview of how to use the right and left functions in SQL Server.
  • SQL Server Functions and Oracle Equivalent1/9/2023 11:15:39 AM. This article looks at SQL Server string, numeric and date functions and their Oracle equivalents.
  • MySQL Functions10/5/2020 2:52:30 PM. In this tutorial, I have described various MySQL Functions in detail with various examples.
  • SQL DATE TIME Statement1/28/2020 1:47:55 PM. In this article you will learn how to use a SQL DATE TIME statement
  • Must-Know SQL Functions For All .NET Developers7/2/2019 2:30:37 AM. This article explains the most commonly used and must-know SQL Server functions and techniques that help and are handy in daily .NET Development and working with SQL Server Database projects.
  • Multi-Line table valued function12/1/2015 10:54:27 AM. This video explains creating multi-line table valued function which returns a table defined by the function itself.
  • Lead And Lag Functions In SQL Server11/20/2015 7:24:22 AM. In this article you will learn how to work with lead and lag functions in SQL Server.
  • Functions in SQL Server4/30/2014 10:29:12 AM. Here, we will take a look at how to use functions in SQL Server.
  • DateTime Functions in SQL Server 20123/18/2014 11:58:58 AM. This article describes all the new DateTime functions introduced in SQL Server 2012 with examples.
  • Lead and Lag Function in SQL Server 20122/17/2014 3:13:27 PM. This article explains the SQL Server 2012 two new analytical functions LEAD and LAG.
  • Functions in SQL Server10/3/2013 3:05:03 PM. This article defines how to use SQL Server built-in functions.
  • Error Handling Functions in SQL Server 201212/29/2012 1:56:17 PM. In this article, you will see some of the SQL Server Error functions which provide information about the error.
  • Global Variables in SQL Server 201211/5/2012 12:33:39 PM. This article contains the most commonly used global variables in SQL Server under a single article with examples.