Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating stored procedures with sqlExec()
Message
 
 
To
13/05/2004 11:03:06
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00903526
Message ID:
00903623
Views:
13
You're welcome.

>Thank you! Now it works all fine
>
>>Jörg,
>>
>>The SQLEXEC() doesn't like '?' (question mark) because it's used as SPT parameter marker. I don't know how you could pass '?' if you have to but in this case you can just remove it.
>>BTW, you can use < pre > and < /pre > tags (w/o spaces) to preserve code formatting.
>>
>>>here the code that I cannoct send with pass through:
>>
>>...
>>>
>>>                 /* Kein Eintrag in Nummernkreis?*/
>>>                 if not(@tcNextLfdNr > space(10) or @tcNextLfdNr > '') -- goto ...
>>
>
>>>The error I get is: sql parameter is missing.
>>>With cut and paste in Entprise Manager od Query Analyser it works fine.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform