[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