Hi,
I want to query data from using ADO, the SQL as following:
Select * from Suppliers where SuppID in ('111', '222', '333'),
How to set parameters for this kind of SQL statement from client?
Thank you very much!
Junlin Xie
by Junlin Xi » Tue, 11 Jun 2002 18:55:39
Select * from Suppliers where SuppID in ('111', '222', '333'),
How to set parameters for this kind of SQL statement from client?
Thank you very much!
Junlin Xie
by Val Mazu » Tue, 11 Jun 2002 23:39:16
Check next link
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q18173... --
> Select * from Suppliers where SuppID in ('111', '222', '333'), > How to set parameters for this kind of SQL statement from client? > Thank you very much! > Junlin Xie
-US&rnk=6&SD=msdn&FR=0&qry=howto%20execute%20query%20using%20ADO&src=DHCS_M
PSS_msdn_SRCH&SPR=MSALL&
Val Mazur
Microsoft MVP
Quote:> Hi,
> I want to query data from using ADO, the SQL as following:
HEEEELLLLLP!!!!
MMMMMMMEEEEEEEEEEEEEEEE!!!!!
How can i add a www-URL ?
Mail me !
http://rsoft.home.pages.de
3. Separate 'StringName' into 'Last', 'First', 'Middle'
5. xp_grantlogin 'Administrators','admin'
6. @@SPID and other system variables
7. IF- statements in a rule's 'DO INSTEAD SELECT ...'- statement
8. Implementing security ... sybase ...
9. IF- statements in a rule's 'DO INSTEAD SELECT ...'-
10. IF- statements in a rule's 'DO INSTEAD SELECT ...'- statement
12. IndexDefs.Add('Help','Please',[ixD2WorksGreat, ixD3Errors])
13. ''''