Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: MS SQL Stored Procedure Syntax

by Arguile (Hermit)
on Sep 27, 2001 at 09:46 UTC ( #115007=note: print w/ replies, xml ) Need Help??


in reply to MS SQL Stored Procedure Syntax

No, what's he's trying to do here is EXEC[UTE] a stored procedure in MS SQL from the sound of it. The CALL syntax is Oracle's, you're getting your SQL dialects mixed up.

$sth = $dbh->prepare('EXEC sp_spaceused');

MSDN has an online transact SQL reference which I suggest you bookmark. Dealing with multiple dialects of the same language can get confusing no matter your experience level.

Abbrv. Superset/Dialect Name Vendor
PL/SQL Procedural Language/Structured Query Language Oracle
T-SQL Transact[ional] Structured Query Language Microsoft


Comment on Re: MS SQL Stored Procedure Syntax
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://115007]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (8)
As of 2015-07-30 07:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (270 votes), past polls