function in SQL

Everything about function in SQL

1. 
   Article · SQL Server

   Functions In SQL Server: A Beginner's Guide

   This article explains how to create functions in SQL Server using the SQL function operator.

   RakeshJul 24, 2023733,9881,000
2. 
   Article · SQL Server

   SQL Security Functions: Part 4

   In this article I describe the Transact-SQL security functions SUSER_ID , SUSER_NAME , SUSER_SID , SUSER_SNAME and SYSTEM_USER.

   Sharad GuptaMar 3, 202311,2241,000
   
3. 
   Article · SQL Server

   SQL Security Functions: Part 2

   In this article, I describe the Transact-SQL security functions IS_MEMBER , IS_SRVROLEMEMBER , LOGINPROPERTY, ORGINAL_LOGIN, and PERMISSION.

   Sharad GuptaMar 3, 202310,6721,000
   
4. 
   Article · SQL Server

   SQL Security Functions: Part 1

   In this article, I describe the Transact-SQL security functions CURRENT_USER, HAS_DBACCESS, HAS_PERMS_BY_NAME, and HASHBYTES.

   Sharad GuptaMar 3, 20239,1431,000
   
5. 
   Article · SQL Server

   String Functions in SQL Server

   This article explains various string functions in SQL Server.

   Pankaj Kumar ChoudharyJan 9, 202337,8781,000
   
6. 
   Article · SQL Server

   APPROX_COUNT_DISTINCT Function In SQL

   We all have written queries that use COUNT DISTINCT to get the unique number of non-NULL values from a table. This process can generate a noticeable performance hit especially for larger tables with millions of rows. Many times, there is no way around this. To help mitigate this overhead SQL Server 2019 introduces us to approximating the distinct count with the new APPROX_COUNT_DISTINCT function.

   Monica RathbunJan 5, 20198,4661,000
   
7. 
   Article · SQL Server

   Convert Local Time From Other Time Zones In SQL Server

   This article consists of examples to resolve issues related to find out time as per different time zones and basic time related functions.

   Gagan SharmaNov 23, 201596,8511,000