question

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?
 
G

Guest

If the "Dba person" worked for me, he would be looking for a new job today,
my friend.
Peter
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is the correct way to do this? 3
Sending dynamic fields to a store procedure 1
Creating db from SQL statements 2
CommandType = TEXT vs Stored Procedure. 4
schedule sql server stored procedures defined in a table?? 1
preventing duplicate row insertion from asp.net app 2
Access 07: Creating Procedures 14
Table Adapter Configuration Wizard replaces data table name with stored procedure's 1

Top