Hi Greg,

I found it while right clicking on the Server name.

Thanks for the help

Mike

That great to know, thanks for your help!

I was just looking for the SQL syntax to create the table format

Getting an error

mysql> CREATE TABLE `product` (

`Producttype` varchar(4) collate latin1_general_ci default NULL,

`ProductName` varchar(80) collate latin1_general_ci default NULL,

`ProductNo` decimal(50,0) primary key identity (1,1),

...

Im not too sure why we use SELECT 1, could you explain to me what this does??

No, SSN is now the primary key as I change the structure.

Thanks for you help

Im getting the following error for the code

CREATE TRIGGER trg_PreventInvalidHours ON Works_On AFTER UPDATE AS

IF EXISTS (SELECT 1 FROM inserted i inner join deleted d

on i.ESSN = d.ESSN WHERE...

Sorry my mistake

SSN is the Primary Key while ESSN is a forign key

Oh ok, thanks for your help

So in your code

I should just replace...

Would that be the complete code that i need or do i have to adjust it?

Where could I insert an error msg like:

INSERT INTO Errormessages 9message)

SELECT 'Working Hours reduction not...

Thats great, I'll have a play around with that tonight.

Thanks for all your help

No I know that I was just wondering if it was posible to code a confirmation msgbox to to show the user that the action has taken place

Thsts a great help guys as I was just using 'ssn' and couldnt figure out why it wasnt deleting.

I like the statment

IF @@Error <> 0

BEGIN

RAISERROR 50001 ' Error...

Hi Kev,

Its not an assignment its just some lab work Im doing today at 1. Thanks for the pointers though. It makes things a little clearer in my head

Two...

Im forced to just use the TRIGGER for the question im being asked