actual differecne between SQL Server's STORE PROCEDURES and USER DEFINED FUNCTIONS ? i looked up these in google but couldn't satisfy me. Differences ? better to use ? and why does UDF can only implement SELECT statements not else , y ?
Recommended Answers
Jump to PostStored procedures and functions seem to be similar and they can be but they are generally used for different reasons. purposes. You can use user defined functions to process input and return output, very similar to a typical program. Stored procedures are created when you need more processing. Updating records, …
Jump to PostOk, so I'm very greatful that you created this thread. I've been misinformed and was not completely well versed in accessing functions from asp.net.
It it supported and easy to do. I created a simple scalar function that accepted one paramter. Called the function from my code-behind and had no …
All 6 Replies
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
HunainHafeez
9
Posting Whiz
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
HunainHafeez
9
Posting Whiz
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
HunainHafeez
9
Posting Whiz
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.