Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating stored procedures with sqlExec()
Message
 
 
To
13/05/2004 10:28:18
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00903526
Message ID:
00903602
Views:
11
This message has been marked as the solution to the initial question of the thread.
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
Next
Reply
Map
View

Click here to load this message in the networking platform