Friday 2 March 2012

Main difference between execute query and execute nonquery and execute reader in sql server 2005/2008

EXECUTE QUERY

ExecuteQuery() is for command objects i.e., this method will send "select statement" to database and returns value given by the database. Moreover the executeQuery() is not used in .net but it is used in JAVA.

 





EXECUTE NONQUERY
ExecuteNonQuery() uses the "Insert/Update/Delete/Stored subprogram" , this method will return number of records effected by the database table.

EXECUTE READER

Use database query is going to provide a set of records. It may be search or report.

No comments:

Post a Comment