Hi there,
Quick question to those more seasoned than me. I often use VB 2005 to select data from a local DB. I usually use a stored procedure, but have occasionally just hard coded my query into my program. My question is, which is faster/ more efficient? Are there any advantages/disadvatages to using a stored procedure?
Thanks,
Bill M.
Quick question to those more seasoned than me. I often use VB 2005 to select data from a local DB. I usually use a stored procedure, but have occasionally just hard coded my query into my program. My question is, which is faster/ more efficient? Are there any advantages/disadvatages to using a stored procedure?
Thanks,
Bill M.