Shedding Light on Stored Procedures
-
Hello. I've read my text book and it tells me how to use stored procedures but it doesn't tell me what they are, how to create them and how to use the values returned. I've looked through the MSDN and maybe I'm typing in the wrong things cause I cant find the information I want. Can anyone help? What I am after is:- 1. How can I create stored procedures in Access 2003? 2. What do I do with them in VB.NET 2003 A table I have in a data base is called Houses. It contains a house address, phone number etc. How could I use a stored procedure to find a certain address or to find the next auto-number for my primary key field. Many Thanks The FOZ
-
Hello. I've read my text book and it tells me how to use stored procedures but it doesn't tell me what they are, how to create them and how to use the values returned. I've looked through the MSDN and maybe I'm typing in the wrong things cause I cant find the information I want. Can anyone help? What I am after is:- 1. How can I create stored procedures in Access 2003? 2. What do I do with them in VB.NET 2003 A table I have in a data base is called Houses. It contains a house address, phone number etc. How could I use a stored procedure to find a certain address or to find the next auto-number for my primary key field. Many Thanks The FOZ
-
Hello. I've read my text book and it tells me how to use stored procedures but it doesn't tell me what they are, how to create them and how to use the values returned. I've looked through the MSDN and maybe I'm typing in the wrong things cause I cant find the information I want. Can anyone help? What I am after is:- 1. How can I create stored procedures in Access 2003? 2. What do I do with them in VB.NET 2003 A table I have in a data base is called Houses. It contains a house address, phone number etc. How could I use a stored procedure to find a certain address or to find the next auto-number for my primary key field. Many Thanks The FOZ
Access doesn't support real stored procedures. It can only handle single statement stored queries, which it called a stored procedure. A real stored procedure is a set of SQL instructions that manipulates a database, tables, rows, or fields. They can be used to do anything in a database, but especially to perform simplex to very complex database lookups, updates, inserts, or deletes. Stored procedures can return no data, single values, a dataset (records), or multiple datasets (multiple sets of records). Dave Kreskowiak Microsoft MVP - Visual Basic
-