Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OpenRowSet() and parameterization
Message
 
À
14/06/2021 15:04:31
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01681195
Message ID:
01681208
Vues:
34
Hi,

I don't understand why you "lost" temporary table.
I use tow ways:
1) dynamic SQL with EXECUTE
2) OLE-DB

MartinaJ

>OpenRowSet() does not allow to use variables for its parameters. We have to either encapsulate the entire command into a string and SQL exec that or find another way. The first one is complicated as we loose the scope of our temporary table. Anyone has a better approach to resolve that issue?
>
>The problem is that the interpreter for the Stored Procedure is very smart. It detects the name of the Excel file and will not compile if the file does not exist.
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform