Yahoo Poland Wyszukiwanie w Internecie

Search results

1. learn.microsoft.com › en-us › sqlCREATE FUNCTION (Transact-SQL) - SQL Server | Microsoft Learn

   learn.microsoft.com › en-us › sql

   • Zapisane w pamięci cache

   26 kwi 2024 · Creates a user-defined function (UDF), which is a Transact-SQL or common language runtime (CLR) routine. A user-defined function accepts parameters, performs an action such as a complex calculation, and returns the result of that action as a value. The return value can either be a scalar (single) value or a table.

2. www.sqltutorial.net › create-functionCREATE FUNCTION – SQL Tutorial

   www.sqltutorial.net › create-function

   • Zapisane w pamięci cache

   Learn how to create a user-defined function (UDF) in SQL using the CREATE FUNCTION statement. See the basic syntax, the components of the function body, and an example of a function that calculates the square of a number.

3. stackoverflow.com › questions › 14550486How to create a function in SQL Server - Stack Overflow

   stackoverflow.com › questions › 14550486

   27 sty 2013 · CREATE FUNCTION dbo.StripWWWandCom (@input VARCHAR(250)) RETURNS VARCHAR(250) AS BEGIN DECLARE @Work VARCHAR(250) SET @Work = @Input --SET @Work = REPLACE(@Work, 'www.', '') SET @Work = Stuff(@Work,1,4, '') SET @Work = REPLACE(@Work, '.com', '') RETURN @work END

4. www.tsql.info › stored-procedures › create-functionT-SQL Create Function syntax and example - T-SQL Tutorial

   www.tsql.info › stored-procedures › create-function

   • Zapisane w pamięci cache

   Learn how to create scalar and table-valued functions in SQL Server database using T-SQL language. See the syntax, parameters, data types, and examples of functions.

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

   learn.microsoft.com › en-us › sql

   • Zapisane w pamięci cache

   27 wrz 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.

6. sqlserverguides.com › how-to-create-function-in-sql-serverHow to CREATE FUNCTION in SQL Server

   sqlserverguides.com › how-to-create-function-in-sql-server

   • Zapisane w pamięci cache

   26 lut 2024 · I will show you how to CREATE FUNCTION in SQL Server in this SQL Server tutorial. You will understand what function is, why to use the function, and how it reduces the repetitive task by encapsulating complex logic. Then, with syntax, you will understand how the function is created in SQL Server.

7. learn.microsoft.com › en-us › sqlUser-defined functions - SQL Server | Microsoft Learn

   learn.microsoft.com › en-us › sql

   • Zapisane w pamięci cache

   29 lip 2024 · User-defined table-valued functions (TVFs) return a table data type. For an inline table-valued function, there's no function body; the table is the result set of a single SELECT statement. For examples, see Create user-defined functions (database engine).