C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Abhi (63)
Appukuttan (40)
divya (36)

Last 7 Days

more...

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

User Defined Functions in SQL Server.

Posted Date: 18 Jun 2008	Resource Type: Definitions	Category: General
Author: Gaurav Agrawal	Member Level: Silver
Rating:	Points: 5

1. Functions are compiled and executed at run time.
2. Function Can not affect the state of the database which means we can not perform insert,delete,update and create operations on the database.
3.Functions should return atleast one out parameter and can return more than one parameter by using out parameter.
4. Functions are basically used to compute values. We passes some parameters to functions as input and then it performs some operations on the parameter and return output.
5.Function can not change server environment and our O.S environment.
6.Functions can not be invoked from SQL Statements. Ex. SELECT
7.Functions can run an executable file from SQL SELECT or an action query.

Responses

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

Feedbacks

Popular Tags

What are tags ?

Search Tags

SQL Server .

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: Extended Stored Procedure
	Previous Resource: Query string
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design