Database

Jerry Hammond wrote:

Why would you have parts with the same part number

CREATE PROCEDURE [dbo].[GetPartDescriptions2]<br />
<br />
@PartType varchar (60)<br />
<br />
 AS<br />
<br />
SELECT PartTypes.ID, PartTypes.description,<br />
CASE when PartTypes.ID = @PartType then 1<br />
else PartTypes.ID<br />
end as order_by<br />
from PartTypes INNER JOIN parts p on p.PartTypeID = PartTypes.ID<br />
<br />
ORDER BY order_by<br />
<br />
But I was getting confused and the bolded parts are not right. I am passing in the part number so it should be something like this:<br />
<br />
<code>CREATE PROCEDURE [dbo].[GetPartDescriptions3] <br />
@PartNumber varchar (60)<br />
<br />
 AS<br />
<br />
SELECT PartTypes.ID, PartTypes.description, Parts.PartNumber, Parts.PartTypeID<br />
CASE when PartTypes.ID = Parts.PartTypeID then 1<br />
else PartTypes.ID<br />
end as order_by<br />
from PartTypes INNER JOIN parts p on p.PartTypeID = PartTypes.ID<br />
<br />
ORDER BY order_by<br />
GO

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?