Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
| Search | Today's Posts | Mark Forums Read
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #11 (permalink)  
Old June 17th, 2003, 07:44 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Sydney, NSW, Australia.
Posts: 215
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You make a very good point. We aren't always able to change all existing code to fit a newer and better way of doing things when we discover them.

On SQL injection, basically the read the paper I linked to. This is by far the best thing I have read on the subject. The comments I made on SQL injection are a rough and condensed version of what I picked up from the paper.

I can't point to any neat papers on how to use SQL Server, I can only speak from my own experience and from the comments of others on this and other mailing lists. SQL Server is extremely good at working with data, so that is what I use it for. All data manipulation is done in stored procedures, ie no SQL is ever generated or executed in the app. Instead procs are executed.

Sounds like you have a good handle on layered development.

regards
David Cameron
  #12 (permalink)  
Old June 18th, 2003, 08:08 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: McPherson, Kansas, USA.
Posts: 128
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I guess I need to apologize I completely over looked the link in your previous post.

Thanks

Larry Asher




Similar Threads
Thread Thread Starter Forum Replies Last Post
T-SQL statement causing error with insert/update saf SQL Language 0 September 7th, 2007 04:48 PM
Creating an INSERT INTO SQL statement for 2 tables sburgess Access 1 April 18th, 2007 08:52 AM
Help with SQL Insert statement in VBA Code ausmoran Access VBA 1 December 28th, 2006 06:16 PM
Insert Statement Iashia06 Access 0 April 7th, 2006 12:45 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.