Why click n? drag IT may elude us

TalkBack 1 of 12:

Next »

• Thread View
• Flat View

Stored Procedures

Yes, use SQL. As I upsized an Access app to a SQL Server back end, I discovered I could eliminate a tremendous number of workarounds by leveraging SQL views, functions and stored procedures. Views are good - see if ASA supports something similar to MS-SQL's table functions, which give kind of a combination of a stored proc and a view - a view that takes parameters. Stored procs are also faster at updating than using recordset operations, although this is more imortant when you have lots of operations to do - looping through a recordset is *slow*.

Posted by: john_hopkins   Posted on: 06/24/04 You are currently: a Guest | Members login | Terms of Use

Alert moderator to an offensive message

Subscribe to this discussion via Email or RSS

SponsoredWhite Papers, Webcasts, and Downloads

• Virtualization: Architectural Considerations And Other Evaluation Criteria VMware Of the many approaches to x86 systems virtualization available in the ... Download Now
• The Impact of Virtualization Software on Operating Environments VMware Today's use of virtualization technology allows IT professionals to ... Download Now
• Why Isn't Server Virtualization Saving Us More? A Few Small Changes May Dramatically Increase Your Efficiency VMware Companies have rapidly adopted server virtualization over the past few ... Download Now