Re: @Variable equivalent in OLEDB?
- From: adreform@xxxxxxxxx
- Date: 15 Apr 2006 11:02:53 -0700
Thanks! You're a lifesaver... and additionally, the only person on the
whole internet that seemed to know that :)
Erland Sommarskog wrote:
(adreform@xxxxxxxxx) writes:
Quite simply, I'm looking for an equivalent to SQL's @variables in
OLEDB. Every time I try to use one in my Visual Studio TableAdapter
query, I'm getting an error that it can't parse this. How can I work an
OLEDB query to have a value passed in?
OLE DB uses the same syntax as ODBC, that is ? as a parameter marker.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- @Variable equivalent in OLEDB?
- From: adreform
- Re: @Variable equivalent in OLEDB?
- From: Erland Sommarskog
- @Variable equivalent in OLEDB?
- Prev by Date: Re: Accessing Excel data - Some columns are not coming through
- Next by Date: Re: 64 bit OLE DB Provider for ODBC
- Previous by thread: Re: @Variable equivalent in OLEDB?
- Next by thread: help. can't connect to sql server express with OleDbConnection
- Index(es):
Relevant Pages
|
Loading
