By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,852 Members | 2,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,852 IT Pros & Developers. It's quick & easy.

Using Triggers / Stored procedures

P: 28
Hi guys,
let me know the difference between the use of direct queries and the stored procedures [SQL Server] / Triggers. also pls specify the advantages of using the stored procedures / triggers.
Jan 29 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 5K+
P: 8,127
Since stored procedure is a pre compiled block of code it is not parsed again at runtime. But a sql statement executed directly every time has to pass through parsing . So performance wise procedures executes faster in comparison to simple SQL.
Jan 29 '08 #2

Expert 5K+
P: 8,434
I'd suggest you ask this question in the SQL Server forum. It's not specific to VB, and you should find more specialists there who can give you a more authoritative answer.

Plus, though you did specify that you're working with SQL Server, you'll find a lot of database expertise in the Access forum.
Jan 29 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.