- The first time written SQL custom function ...! - Analysis (Review) Process - DROP Function Areatoc Delete Function Areatoc
Create Function Areatoc (@farea float) returns float - Function Return Type Just write a S
AS Begin Declare @fr float - Declare Defining Variable Declare @fc float set @fr = SQRT (@farea / pi ()) --sqrt, Pi is system function set @fc = 2 * pi () * @ frreturn (@ FC) - Braces here can be written without end
- Execute the function definition language block before using the function, which is equivalent to registering the name in the database
--TestDeclare @c float, @Area floatset @At = 8set @c = dbo.areatoc (@Area) - DBO. These symbolic activation functions, DBO database users,
- I didn't have a busy for half a day in the first time, SELECT @c as 'circumference', @ArEa as 'area'
--Test2Select dbo.areatoc (3) As 'Areatoc'
No one is born is a genius, and the statement on the upper state is really the answer to the prompt of the SQLServers 2000.
Differently use several instructions used by the Google Engine to find information, perhaps useful Site "Specific content"
ASM Site: 9cbs.com Site: -9cbs.com Site: CNASM Site: TW
FILETYPE has a class of files with the same extension FILETYPE: DOC Graduation Thesis
InURL keywords are included in URL connection ASM inURL: Download
Link connects a URL address of the net link: 9cbs.com
Related Similar Network Leaf Relate: ftp.microsofe.com Search FTP Resources
