parameterised Queries

[John]

Hi

New to sql server. using beta2 2005. What is the way to implement
parameterised queries? I need the queries to be updatable as these would
work as recordsets that vb.net forms will be bound to for data entry.

Thanks

Regards

[David Portas]

Create parameterized stored procedures for your data access code.

http://msdn.microsoft.com/library/de...un_1a_6x45.asp
http://www.sql-server-performance.co...procedures.asp

--
David Portas
SQL Server MVP
--

[Eamon]

please can u please post it in here only

Ok m8. give us a table in script and we will write u how to update and
select the data. its really the same as MSDE

E.g

Select Statement in stored procedure

SELECT * FROM #table

Update Statemebt in stored procedure

Update #table SET Titsize = @ Titsize, Shoesize = @Shoesize WHERE name =
@name

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:OV**************@TK2MSFTNGP12.phx.gbl...

Hi

New to sql server. using beta2 2005. What is the way to implement
parameterised queries? I need the queries to be updatable as these would
work as recordsets that vb.net forms will be bound to for data entry.

Thanks

Regards