Collections:
Passing Expressions to Function Parameters in SQL Server
Can You Pass Expressions to Function Parameters in SQL Server Transact-SQL?
✍: FYIcenter.com
Can you pass expressions to stored procedure parameters? The answer is yes.
When executing functions, input values can be written as expressions. But the resulting value data type must match the parameter. The tutorial exercise below shows you how input values should be specified:
USE FyiCenterData; GO CREATE FUNCTION Area(@radius REAL) RETURNS REAL AS BEGIN RETURN 3.14*@radius*@radius; END; GO -- Input value data matches the parameter PRINT 'Area of a circle: '+STR(dbo.Area(1.5),9,3); GO Area of a circle: 7.065 -- Input value data does not match the parameter PRINT 'Area of a circle: '+STR(dbo.Area('1.5'),9,3); GO Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'Area'. -- Expressions are allowed PRINT 'Area of a circle: '+STR(dbo.Area(1.0+0.5),9,3); GO Area of a circle: 7.065
⇒ DEFAULT - Providing Default Values to Function Parameters in SQL Server
⇐ Passing Values to User Defined Function Parameters in SQL Server
2016-12-18, 1671🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...