Yahoo Αναζήτηση Διαδυκτίου

Αποτελέσματα Αναζήτησης

1. www.w3schools.com › sqL › sql_ref_sqlserverSQL Server Functions - W3Schools

   www.w3schools.com › sqL › sql_ref_sqlserver

   • Αποθηκευμένο αντίγραφο

   SQL Server has many built-in functions. This reference contains string, numeric, date, conversion, and some advanced functions in SQL Server.

   • MS Access Functions

     Function Description; CurrentUser: Returns the name of the...

2. www.sqlservertutorial.net › sql-server-user-defined-functionsSQL Server User-defined Functions - SQL Server Tutorial

   www.sqlservertutorial.net › sql-server-user-defined-functions

   • Αποθηκευμένο αντίγραφο

   SQL Server User-defined Functions. In this section, you will learn about SQL Server user-defined functions including scalar-valued functions which return a single value and table-valued function which return rows of data.

3. learn.microsoft.com › en-us › sqlCreate User-defined Functions (Database Engine) - SQL Server

   learn.microsoft.com › en-us › sql

   • Αποθηκευμένο αντίγραφο

   27 Σεπ 2024 · This article describes how to create a user-defined function (UDF) in SQL Server by using Transact-SQL. Limitations and restrictions. User-defined functions can't be used to perform actions that modify the database state. User-defined functions can't contain an OUTPUT INTO clause that has a table as its target.

4. www.mssqltips.com › sqlservertip › 6177SQL Server User Defined Function Example

   www.mssqltips.com › sqlservertip › 6177

   • Αποθηκευμένο αντίγραφο

   In this tip we look at examples for creating SQL Server user defined functions for scalar-valued, table-valued and multi-statement table-valued functions.

5. learn.microsoft.com › en-us › sqlExecute user-defined functions - SQL Server | Microsoft Learn

   learn.microsoft.com › en-us › sql

   • Αποθηκευμένο αντίγραφο

   26 Απρ 2024 · Applies to: SQL Server Azure SQL Database. Execute a user defined function using Transact-SQL. Scalar functions must be invoked by using at least the two-part name of the function (<schema>.<function>). For more information, see CREATE FUNCTION (Transact-SQL).

6. www.tutorialsteacher.com › sqlserver › user-defined-functionsSQL Server Functions: Create, Alter, Call - TutorialsTeacher.com

   www.tutorialsteacher.com › sqlserver › user-defined-functions

   • Αποθηκευμένο αντίγραφο

   User Defined Functions (UDFs): Functions created by the database user are called User-defined functions. UDFs are of two types: Scalar functions: The function that returns a single data value is called a scalar function. Table-valued functions: The function that returns multiple records as a table data type is called a Table-valued function.

7. www.sqlshack.com › learn-sql-user-defined-functionsLearn SQL: User-Defined Functions - SQL Shack

   www.sqlshack.com › learn-sql-user-defined-functions

   • Αποθηκευμένο αντίγραφο

   25 Φεβ 2020 · One of these is definitely user-defined functions. When used as intended, they are a very powerful tool in databases. In today’s article, we’ll see how to create, change and remove them from the database, as well as how to use them.