Database

leckey wrote:

ORDER BY order_by

CREATE PROCEDURE GetColumn 
@returnColumn varchar(100),@table varchar(100),@searchColumn varchar(100), @searchValue varchar(100)
AS

exec('select ' + @returnColumn + ' from ' + @table + ' where ' + @searchColumn + ' = ' + @searchValue)

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?