Retrieving Data

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi

I have some 10 records in a table with a DateTime field, all the records
have the same data but the time of each records is different.

Using a stored procedure how do i retrieve all records

eg AppendParameter(cmd, "@CallDate", DbType.DateTime, dt);

TIA
Barry


.

Relevant Pages

  • Re: Parameter to a Stored Procedure
    ... in SQL Server it is a datetime field. ... But thanks for the heads up for Access. ... >> I'm calling a stored procedure from vb asp and setting a few ...
    (microsoft.public.data.ado)
  • Re: Updating in memory datatable efficiently.
    ... If you have an "updated" DateTime field in your source table you'll be able ... - to retrieve which records have been updated (and if no records you can ... Patrice ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • sql server balnk date
    ... I want to put a blank value into a datetime field in sql server 2005. ... The following is part of the stored procedure that is called by the vb.net ... that is why I want the value in the second inswert statement to be blank. ...
    (microsoft.public.sqlserver.tools)
  • how to make date blank when get date returned as 1/2/1900.
    ... I want to put a blank value into a datetime field in sql server 2005. ... The following is part of the stored procedure that is called by the vb.net ... that is why I want the value in the second inswert statement to be blank. ...
    (microsoft.public.sqlserver.programming)
  • Re: Access DB Datetime
    ... a datetime field. ... I would like to retrieve both the date and the time, but VB only seems to return the date. ... How do I get the time executing the query from VB? ... 'John Mishefske ...
    (microsoft.public.vb.database)