C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

SQL User Defined Functions

Posted Date: 04 Sep 2008 Resource Type: Articles Category: .NET Framework

Posted By: VASANTH R Member Level: Gold
Rating:

Points: 3

a. Scalar UDF: It returns a scalar value with datatype such as int, nvarchar, char, datetime and money
b. Table Valued UDF i. Inline Table value returning UDF -It defined with a single SELECT statement making up the body of the function. Inline table value-returning UDFs cannot contain additional T-SQL logic outside of the SQL SELECT statement that defines the table it will return. ii. Multistatement Table value returning UDF - This UDF is used if any additional logic needs to be included in the UDF in addition to select Statment. It allows to define multiple statement inside the UDF

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

User Defined Functions . UDF . SQL 2005 .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Generic Collections - Feature of DotNet 2.0
	Previous Resource: Using session in asp.net
	Return to Discussion Resource Index
	Post New Resource
	Category: .NET Framework

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

UK Conference calling Company