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, 1670🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...