data adapter command type advise

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

John

Hi

In data adapter I have a choice to select command types text, stored
procedure or table direct. Which one is most appropriate for sql server 2005
backend.

Many Thanks

Regards
 
In most cases, you should choose Stored Procedure, meaning, you specify a
stored procedure's name, which has already be created in the targeting SQL
Server database, doing the required SELECT/UPDATE/DELETE...
 
Back
Top