Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>>Has someone come up with any kind of automation tool to build these sql strings with 1000000000000 number of single quotes?
>>>
>>>What strings are you referring to and what is the problem?
>> Something like this:
>>
>>declare @sql_str char (4000)
>>set @sql_str =
>>'select * from openquery(VAMCPD,
>>''select a.cItemno,a.nShipQty,a.nSalesAmt-a.nDiscAmt as Amt
>> from aritrs a
>>inner join arinvc b on a.cInvNo=b.cInvNo
>>where a.cCustno+a.cInvNo like ''' + '''59002' + '%''' + ''' and cType= '''''
>>+ ''''''')'
>>--select @sql_str
>>exec (@sql_str)
>>
>>it took just a couple hours, or even more. I am trying to add more parameters to a query and it is a nightmare.
>
>Sorry but I still do not understand what you're doing and where. Do you build the string in VFP or in SQL Server stored procedure? Where parameters comes from and how?
I am going to have a SQL SP to run this code. Parameters will be sent into that procedure.
The problem is building correct SQL string with all these quotes.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement