question

  • Thread starter Thread starter John
  • Start date Start date
J

John

I took over an existing .NET 1.1 app and when its getting data its using
about 99% of inline SQL statements, such as SELECT * from table, or UPDATE,
and INSERTS, and its also doing some SELECT on views. I would like to
convert all of the inline SQL statements into stored procedures, but the DBA
person will not create a stored procedure for select statements. So my
question is, should inline SQL statements be used for SELECT * from table or
SELECT * from table where name = name, or should stored procedures be used?
 
If the "Dba person" worked for me, he would be looking for a new job today,
my friend.
Peter
 
Always use stored procedures for security and performance reasons. Also
please make your DBAs work because they should know the effective ways of
querying tables by using indexes, etc. better than most developers.
 
Back
Top