Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JBelthoff
Posting Yak Master
173 Posts |
 Posted - 2001-07-14 : 08:42:39
|
Hello,I have another newbie question. When dealing from VB/ASP to do an insert I would set the lock prperty to either "adLockOptimistic" or adLockPesimistic" to add a new record.I have created the following a Stored Proc. Do I need to worry about locking when adding a record this way?Are there any other considerations I should be considering by using the following SP?Maybe someone could direct me to an area of learning that would be appropriate for my level. I have ordered some books but I always like to jump in head first when learning something new.CREATE PROCEDURE sp_MeteorFactInsert @FName nvarchar(25), @LName nvarchar(50), @Email nvarchar(75),AS INSERT INTO METEOR_FACTS(D_FName, D_LName, D_Email)VALUES(@FName, @LName, @Email)GOThank you,John Belthoff  |
|
|
|
|
|
New Records and Locking?