[dba-SQLServer] Views With Parameters ?

Thought as much, thank you.





Message date : Jul 21 2004, 01:22 PM
>From : "Mike & Doris Manning" 
To : dba-sqlserver at databaseadvisors.com
Copy to : 
Subject : RE: [dba-SQLServer] Views With Parameters ?
To my knowledge, views don't take parameters...only Stored Procedures do...

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: Wednesday, July 21, 2004 7:59 AM
To: dba-sqlserver
Subject: [dba-SQLServer] Views With Parameters ?


To all,
Is it possible to create a parameter type view in SQL Server 7.0, which I
can then call from Visual Basic 6. Something like SELECT * FROM
tblPersonnel WHERE tblPersonnel.PayrollNo = ? and then in VB something
like rsPerson.Open("Query '" & Me.PayrollNo & "'"),OpenSQLConn etc etc
Paul Hartland

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at:
http://www.wanadoo.co.uk/help/id/7098.htm
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm