SQL Server Stored Procedure

5 pts.
Tags:
SQL Server stored procedures
An interesting question asked to me. We always mention, we can do lots of things inside a SQL Server Stored Procedure. But does anyone know what cannot be done inside a SQL Server Stored Procedure?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Anything that you can do as a normal T/SQL statement can be done via a stored procedure. In some cases you may have to use dynamic SQL do to them however. For example you can’t create a stored procedure from within another stored procedure unless you use dynamic SQL. The big requirement is that you have to have access to perform the operation.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • VelameLaCosa
    So can you execute or call a UNIX shell script from within a Stored Procedure?
    110 pointsBadges:
    report
  • carlosdl
    Can that be done as a normal T/SQL statement ?
    70,220 pointsBadges:
    report
  • Denny Cherry
    You can by shelling out to the DOS command shell via the xp_cmdshell extended stored procedure. However running a UNIX shell script from a Windows server presents it's own issues.
    66,365 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following