Database

<br />
create proc myProc    @Account int  AS<br />
<br />
-- Select ALL RECORDS<br />
if @Account = 0 <br />
 BEGIN<br />
    SELECT * FROM Accounts<br />
 END<br />
ELSE<br />
-- SELECT SINGLE ACCOUNT<br />
 BEGIN<br />
     SELECT * FROM Account<br />
     WHERE ID = @Account<br />
 END<br />
<br />

zouchao1112 wrote:

1. how to input the date-time format: "1987-12-29 12:23:45" into Access DB with InputMask?

zouchao1112 wrote:

if I want to query the record that has the date-time before "1987-12-29 12:23:45" and after "1986-10-15 23:25:26", how do I write the sql string?

CREATE PROCEDURE SelectRecipient
AS
DECLARE @mail nvarchar(4000)
Select Mail FROM Member
select Mail from Member
exec @mail = SelectRecipient
select @mail
GO

CREATE PROCEDURE SelectRecipient
AS
SELECT Mail from Member
GO

SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandTypeStoredProcedure;
cmd.CommandText = "SelectRecipient";
cmd.Connection = myConnection;
SqlReader reader = cmd.ExecuteReader()
while(reader.Read())
{
    string mail = reader.GetString(0);
    // Do something with the result
}

CREATE PROCEDURE SelectRecipient
@Recipient varchar(40)
AS
Select Mail FROM Member
Where Member = @Recipient
GO

TheinstruTara wrote:

But how do write the sql if I want both the 1st row and the 3rd row. They both differ in only the Param name.