Connectiong to a View using Classic ASP
stimpy | Posted 9:56am 3. October 2007 Server Time |
How do you connect to a view in a SQL 2k5 DB using Classic ASP?
Also, cna you pass in parameters into a view? |
valkyr | Posted 2:04am 9. October 2007 Server Time |
You treat a View just like you would treat a table. You just need to use a simple SELECT statement with the view name rather than a table name, same rules for WHERE and GROUP BY clauses apply.
i.e.
SELECT * FROM MyView WHERE SomeColumn LIKE 'wibble%'
stimpy | Posted 3:02am 9. October 2007 Server Time |
Thanks!
Reply to Post Connectiong to a View using Classic ASP
|
|
|
