Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Teradata and SQL RS

Author  Topic 

peterlemonjello
Yak Posting Veteran

53 Posts

Posted - 2006-04-04 : 16:11:26
Anyone know how to use parameters with the Teradata ODBC driver? I've tried @parametername and :parametername and keep getting errors.

peterlemonjello
Yak Posting Veteran

53 Posts

Posted - 2006-04-05 : 10:32:29
Found the answer. Teradata doesn't use named parameters so a '?' is used. Be sure to specify parameters in the correct order.

Example:
select FirstName, LastName
from employee
where employeeID = ?
Go to Top of Page
   

- Advertisement -