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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-11 : 17:52:37
|
Steve gallagher writes "I am using ASP with Oracle as the database.
I am concerned that if you use a sql statement from an ASP such
as:
select * from emp where empno = '123456'
The problem is that Oracle has to compile this SQL statement
every time it is called and also attempts to find a copy of it.
The answer is bind variables. In Java you can say:
select * from emp where empno = '?'
//and then set ? to be a variable
and this tells Oracle that ? is a bind variable and to not
create a whole new one each time and to not search for anything else.
The question is, how do you do this in ASP??????
Steve G.
" |
|
|
|
|
|
Bind variables