Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > SQL Data Access

Reply
Thread Tools

SQL Data Access

 
 
Kenneth Keeley
Guest
Posts: n/a
 
      05-24-2004
Hi,
Is it safer to use an SQL Stored Procedure or to create the querry in
asp.net code? Which would run faster? and what is the best way to protect my
SQL server from hackers.

Thanks for any help.
Kenneth Keeley


 
Reply With Quote
 
 
 
 
Calvin Luttrell/ProjectThunder.com
Guest
Posts: n/a
 
      05-24-2004
Kenneth,

Use Stored Procedure's with the command objects in ADO.Net. You can give the sql user no rights except to execute those SP's. Running raw SQL is always a risk and runs slower cause SQL doesn't have a pre-built query plan.

-Calvin Luttrell
ProjectThunder.com

> Is it safer to use an SQL Stored Procedure or to create the querry in
> asp.net code? Which would run faster? and what is the best way to protect my
> SQL server from hackers.


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
XML data access or DB data access ? Savvoulidis Iordanis ASP .Net 2 01-07-2009 10:47 PM
SQL Reference, SQL Queries, SQL help ecoolone ASP .Net 0 01-03-2008 10:58 AM
MS Access SQL > ASP SQL problem.... david@scene-double.co.uk ASP General 10 01-06-2005 12:23 PM
Tools to extract data from SQL database and convert it into XML & insert XML data into SQL databases Harry Zoroc XML 1 07-12-2004 10:10 PM
confused about access / sql database / sql server / php !! .. help please cooldv ASP General 3 10-06-2003 01:35 PM



Advertisments