By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,592 Members | 1,931 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,592 IT Pros & Developers. It's quick & easy.

Store Procedure Query

P: n/a
Hello All

I get stuck in one problem , Please help me and excuse me on the poor
Knowledge
in SQL Server Store procedure

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 .
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 .

Q3 ... How to use xp_sendmail.dll in SQL Server.

Thanking you
With regards

Tarun

Feb 18 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

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/c..._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.

Feb 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.