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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 using variables inside SELECT statement

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-24 : 23:54:46
Sander writes "Hi,

server2000 os
we use a SQL2000 db. Retreiving info via sql statement from asp.

I want to do sometging like:

SELECT name_client AS 'name'
FROM table
WHERE bla bla

then inside asp script I want to use the value given to the variable 'name'

btw I use recordset.getrows to retreive info from sql and putting it into a array.

Thanks

Sander"
   

- Advertisement -