Query Create Text Stored Procedure?

[caljohn527]

Can someone explain to be the defense between (Create Text Stored Procedure?)
And (Create Text Scalar Function?) Also (Create Text Table-Valued Function?) In Query.


I am using Access 2002 & SQL Server 2003.
I am a novice at this and need some help.


Thank You for all the help that I reserved and can get..

 

[ByteMyzer]

With a Stored Procedure, a returned result is optional, not required.

With a Scalar Function, a single-value data type is returned.

With a Table-Valued Function, a table data type is returned.