Posted by Jens on 02/18/06 11:43
Q1...I want to return a string type value from store procedure , Is it
possible to do it.if posible then Please guide us how we can do it .
Giving back the string within a output variable:
CREATE
PROCEDURE SomeProc
(
SomeVar VARCHAR(30) OUTPUT
)
AS
--proceduretext with filling the OUTPUT variable
--Giving back the data within a Select statement
CREATE
PROCEDURE SomeProc
AS
SELECT 'SomeText'
Q2...I search a lot on net but i am unable to understand the Extended
Store Procedure.
How to register it and how to use in our store procedure .
http://www.mssqlcity.com/FAQ/Devel/create_extended_stored_procedure.htm
Q3 ... How to use xp_sendmail.dll in SQL Server.
This is already registered on SQL Server and can be used with the
xp_sendmail statement.
HTH, Jens Suessmeyer.
[Back to original message]
|