Using Triggers / Stored procedures

[cvraghavan1979]

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.

regards,
vijay

[debasisdas]

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.

[Killer42]

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.