[MS_AccessPros] RE: All processes based on Sql Server Stored Proc.

 

Hendra

Unless you're talking about millions of records, I don't see a need to use a stored procedure for a SELECT since no action is done on the data. In fact, a view might be better so you can control which columns are being returned. As for the rest, it is usually quicker to let the SQL engine do the work directly for high-use routines when a large number of records are involved.

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___