Database

IF EXISTS ( 
      SELECT * FROM authors WHERE au_lname = 'Green' )
   SELECT * FROM titleauthor
   SELECT * FROM titles

IF EXISTS ( 
      SELECT * FROM authors WHERE au_lname = 'Green' )
BEGIN
   SELECT * FROM titleauthor
   SELECT * FROM titles
END

<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