Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating stored procedures with sqlExec()
Message
From
13/05/2004 09:16:50
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00903526
Message ID:
00903547
Views:
14
You are right and I must have been blind! But some of them still don't work. But they do if I transfer them by 'cut and paste'. Strange isn't it?!

Regards

>Jörg,
>
>Don't include 'GO'. It's not a T-SQL statement but Query Analyzer batch separator. Only QA recognize it.
>
>>Hi Sergey,
>>
>>aerror is telling me somthing about 'too few arguments'! The procedure contains just this:
>>
>>CREATE PROCEDURE dbo.sp_DisableTrigger @tnOnOff numeric=1 AS
>>begin
>>
>>end
>>GO
>>
>>This procedure is stored in an local variable t and I try to send it with
>>sqlExec(h,t), where h is containing the handle.
>>
Jörg Schneider
Joerg.Schneider@SMARTCRM.de
SMARTCRM CRM powered by MS Visual FoxPro
SMARTCRM GmbH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform